package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ClientinfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ClientinfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andClientcodeIsNull() {
            addCriterion("ClientCode is null");
            return (Criteria) this;
        }

        public Criteria andClientcodeIsNotNull() {
            addCriterion("ClientCode is not null");
            return (Criteria) this;
        }

        public Criteria andClientcodeEqualTo(String value) {
            addCriterion("ClientCode =", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotEqualTo(String value) {
            addCriterion("ClientCode <>", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeGreaterThan(String value) {
            addCriterion("ClientCode >", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ClientCode >=", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLessThan(String value) {
            addCriterion("ClientCode <", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLessThanOrEqualTo(String value) {
            addCriterion("ClientCode <=", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLike(String value) {
            addCriterion("ClientCode like", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotLike(String value) {
            addCriterion("ClientCode not like", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeIn(List<String> values) {
            addCriterion("ClientCode in", values, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotIn(List<String> values) {
            addCriterion("ClientCode not in", values, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeBetween(String value1, String value2) {
            addCriterion("ClientCode between", value1, value2, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotBetween(String value1, String value2) {
            addCriterion("ClientCode not between", value1, value2, "clientcode");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andBornnoIsNull() {
            addCriterion("BornNo is null");
            return (Criteria) this;
        }

        public Criteria andBornnoIsNotNull() {
            addCriterion("BornNo is not null");
            return (Criteria) this;
        }

        public Criteria andBornnoEqualTo(String value) {
            addCriterion("BornNo =", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotEqualTo(String value) {
            addCriterion("BornNo <>", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoGreaterThan(String value) {
            addCriterion("BornNo >", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoGreaterThanOrEqualTo(String value) {
            addCriterion("BornNo >=", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLessThan(String value) {
            addCriterion("BornNo <", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLessThanOrEqualTo(String value) {
            addCriterion("BornNo <=", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoLike(String value) {
            addCriterion("BornNo like", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotLike(String value) {
            addCriterion("BornNo not like", value, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoIn(List<String> values) {
            addCriterion("BornNo in", values, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotIn(List<String> values) {
            addCriterion("BornNo not in", values, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoBetween(String value1, String value2) {
            addCriterion("BornNo between", value1, value2, "bornno");
            return (Criteria) this;
        }

        public Criteria andBornnoNotBetween(String value1, String value2) {
            addCriterion("BornNo not between", value1, value2, "bornno");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIsNull() {
            addCriterion("BalanceCode is null");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIsNotNull() {
            addCriterion("BalanceCode is not null");
            return (Criteria) this;
        }

        public Criteria andBalancecodeEqualTo(String value) {
            addCriterion("BalanceCode =", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotEqualTo(String value) {
            addCriterion("BalanceCode <>", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeGreaterThan(String value) {
            addCriterion("BalanceCode >", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceCode >=", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLessThan(String value) {
            addCriterion("BalanceCode <", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLessThanOrEqualTo(String value) {
            addCriterion("BalanceCode <=", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeLike(String value) {
            addCriterion("BalanceCode like", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotLike(String value) {
            addCriterion("BalanceCode not like", value, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeIn(List<String> values) {
            addCriterion("BalanceCode in", values, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotIn(List<String> values) {
            addCriterion("BalanceCode not in", values, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeBetween(String value1, String value2) {
            addCriterion("BalanceCode between", value1, value2, "balancecode");
            return (Criteria) this;
        }

        public Criteria andBalancecodeNotBetween(String value1, String value2) {
            addCriterion("BalanceCode not between", value1, value2, "balancecode");
            return (Criteria) this;
        }

        public Criteria andClientnameIsNull() {
            addCriterion("ClientName is null");
            return (Criteria) this;
        }

        public Criteria andClientnameIsNotNull() {
            addCriterion("ClientName is not null");
            return (Criteria) this;
        }

        public Criteria andClientnameEqualTo(String value) {
            addCriterion("ClientName =", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotEqualTo(String value) {
            addCriterion("ClientName <>", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameGreaterThan(String value) {
            addCriterion("ClientName >", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameGreaterThanOrEqualTo(String value) {
            addCriterion("ClientName >=", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLessThan(String value) {
            addCriterion("ClientName <", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLessThanOrEqualTo(String value) {
            addCriterion("ClientName <=", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameLike(String value) {
            addCriterion("ClientName like", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotLike(String value) {
            addCriterion("ClientName not like", value, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameIn(List<String> values) {
            addCriterion("ClientName in", values, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotIn(List<String> values) {
            addCriterion("ClientName not in", values, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameBetween(String value1, String value2) {
            addCriterion("ClientName between", value1, value2, "clientname");
            return (Criteria) this;
        }

        public Criteria andClientnameNotBetween(String value1, String value2) {
            addCriterion("ClientName not between", value1, value2, "clientname");
            return (Criteria) this;
        }

        public Criteria andNametypeIsNull() {
            addCriterion("NameType is null");
            return (Criteria) this;
        }

        public Criteria andNametypeIsNotNull() {
            addCriterion("NameType is not null");
            return (Criteria) this;
        }

        public Criteria andNametypeEqualTo(String value) {
            addCriterion("NameType =", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeNotEqualTo(String value) {
            addCriterion("NameType <>", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeGreaterThan(String value) {
            addCriterion("NameType >", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeGreaterThanOrEqualTo(String value) {
            addCriterion("NameType >=", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeLessThan(String value) {
            addCriterion("NameType <", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeLessThanOrEqualTo(String value) {
            addCriterion("NameType <=", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeLike(String value) {
            addCriterion("NameType like", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeNotLike(String value) {
            addCriterion("NameType not like", value, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeIn(List<String> values) {
            addCriterion("NameType in", values, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeNotIn(List<String> values) {
            addCriterion("NameType not in", values, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeBetween(String value1, String value2) {
            addCriterion("NameType between", value1, value2, "nametype");
            return (Criteria) this;
        }

        public Criteria andNametypeNotBetween(String value1, String value2) {
            addCriterion("NameType not between", value1, value2, "nametype");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNull() {
            addCriterion("ClientType is null");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNotNull() {
            addCriterion("ClientType is not null");
            return (Criteria) this;
        }

        public Criteria andClienttypeEqualTo(String value) {
            addCriterion("ClientType =", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotEqualTo(String value) {
            addCriterion("ClientType <>", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThan(String value) {
            addCriterion("ClientType >", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThanOrEqualTo(String value) {
            addCriterion("ClientType >=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThan(String value) {
            addCriterion("ClientType <", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThanOrEqualTo(String value) {
            addCriterion("ClientType <=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLike(String value) {
            addCriterion("ClientType like", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotLike(String value) {
            addCriterion("ClientType not like", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeIn(List<String> values) {
            addCriterion("ClientType in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotIn(List<String> values) {
            addCriterion("ClientType not in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeBetween(String value1, String value2) {
            addCriterion("ClientType between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotBetween(String value1, String value2) {
            addCriterion("ClientType not between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andStoretypeIsNull() {
            addCriterion("StoreType is null");
            return (Criteria) this;
        }

        public Criteria andStoretypeIsNotNull() {
            addCriterion("StoreType is not null");
            return (Criteria) this;
        }

        public Criteria andStoretypeEqualTo(String value) {
            addCriterion("StoreType =", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotEqualTo(String value) {
            addCriterion("StoreType <>", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeGreaterThan(String value) {
            addCriterion("StoreType >", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreType >=", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLessThan(String value) {
            addCriterion("StoreType <", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLessThanOrEqualTo(String value) {
            addCriterion("StoreType <=", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeLike(String value) {
            addCriterion("StoreType like", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotLike(String value) {
            addCriterion("StoreType not like", value, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeIn(List<String> values) {
            addCriterion("StoreType in", values, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotIn(List<String> values) {
            addCriterion("StoreType not in", values, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeBetween(String value1, String value2) {
            addCriterion("StoreType between", value1, value2, "storetype");
            return (Criteria) this;
        }

        public Criteria andStoretypeNotBetween(String value1, String value2) {
            addCriterion("StoreType not between", value1, value2, "storetype");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNull() {
            addCriterion("AreaNo is null");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNotNull() {
            addCriterion("AreaNo is not null");
            return (Criteria) this;
        }

        public Criteria andAreanoEqualTo(String value) {
            addCriterion("AreaNo =", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotEqualTo(String value) {
            addCriterion("AreaNo <>", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThan(String value) {
            addCriterion("AreaNo >", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThanOrEqualTo(String value) {
            addCriterion("AreaNo >=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThan(String value) {
            addCriterion("AreaNo <", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThanOrEqualTo(String value) {
            addCriterion("AreaNo <=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLike(String value) {
            addCriterion("AreaNo like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotLike(String value) {
            addCriterion("AreaNo not like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoIn(List<String> values) {
            addCriterion("AreaNo in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotIn(List<String> values) {
            addCriterion("AreaNo not in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoBetween(String value1, String value2) {
            addCriterion("AreaNo between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotBetween(String value1, String value2) {
            addCriterion("AreaNo not between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNull() {
            addCriterion("PYCode is null");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNotNull() {
            addCriterion("PYCode is not null");
            return (Criteria) this;
        }

        public Criteria andPycodeEqualTo(String value) {
            addCriterion("PYCode =", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotEqualTo(String value) {
            addCriterion("PYCode <>", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThan(String value) {
            addCriterion("PYCode >", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThanOrEqualTo(String value) {
            addCriterion("PYCode >=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThan(String value) {
            addCriterion("PYCode <", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThanOrEqualTo(String value) {
            addCriterion("PYCode <=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLike(String value) {
            addCriterion("PYCode like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotLike(String value) {
            addCriterion("PYCode not like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeIn(List<String> values) {
            addCriterion("PYCode in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotIn(List<String> values) {
            addCriterion("PYCode not in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeBetween(String value1, String value2) {
            addCriterion("PYCode between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotBetween(String value1, String value2) {
            addCriterion("PYCode not between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNull() {
            addCriterion("Chairman is null");
            return (Criteria) this;
        }

        public Criteria andChairmanIsNotNull() {
            addCriterion("Chairman is not null");
            return (Criteria) this;
        }

        public Criteria andChairmanEqualTo(String value) {
            addCriterion("Chairman =", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotEqualTo(String value) {
            addCriterion("Chairman <>", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThan(String value) {
            addCriterion("Chairman >", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanGreaterThanOrEqualTo(String value) {
            addCriterion("Chairman >=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThan(String value) {
            addCriterion("Chairman <", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLessThanOrEqualTo(String value) {
            addCriterion("Chairman <=", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanLike(String value) {
            addCriterion("Chairman like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotLike(String value) {
            addCriterion("Chairman not like", value, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanIn(List<String> values) {
            addCriterion("Chairman in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotIn(List<String> values) {
            addCriterion("Chairman not in", values, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanBetween(String value1, String value2) {
            addCriterion("Chairman between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andChairmanNotBetween(String value1, String value2) {
            addCriterion("Chairman not between", value1, value2, "chairman");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andHttpIsNull() {
            addCriterion("Http is null");
            return (Criteria) this;
        }

        public Criteria andHttpIsNotNull() {
            addCriterion("Http is not null");
            return (Criteria) this;
        }

        public Criteria andHttpEqualTo(String value) {
            addCriterion("Http =", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotEqualTo(String value) {
            addCriterion("Http <>", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpGreaterThan(String value) {
            addCriterion("Http >", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpGreaterThanOrEqualTo(String value) {
            addCriterion("Http >=", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLessThan(String value) {
            addCriterion("Http <", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLessThanOrEqualTo(String value) {
            addCriterion("Http <=", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpLike(String value) {
            addCriterion("Http like", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotLike(String value) {
            addCriterion("Http not like", value, "http");
            return (Criteria) this;
        }

        public Criteria andHttpIn(List<String> values) {
            addCriterion("Http in", values, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotIn(List<String> values) {
            addCriterion("Http not in", values, "http");
            return (Criteria) this;
        }

        public Criteria andHttpBetween(String value1, String value2) {
            addCriterion("Http between", value1, value2, "http");
            return (Criteria) this;
        }

        public Criteria andHttpNotBetween(String value1, String value2) {
            addCriterion("Http not between", value1, value2, "http");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("PostCode is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("PostCode is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("PostCode =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("PostCode <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("PostCode >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("PostCode >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("PostCode <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("PostCode <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("PostCode like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("PostCode not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("PostCode in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("PostCode not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("PostCode between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("PostCode not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("Telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("Telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("Telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("Telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("Telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("Telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("Telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("Telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("Telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("Telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("Telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("Telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("Telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("Telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("Mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("Mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("Mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("Mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("Mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("Mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("Mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("Mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("Mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("Mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("Mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("Mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("Mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("Mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("Fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("Fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("Fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("Fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("Fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("Fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("Fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("Fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("Fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("Fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("Fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("Fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("Fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("Fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNull() {
            addCriterion("TaxNo is null");
            return (Criteria) this;
        }

        public Criteria andTaxnoIsNotNull() {
            addCriterion("TaxNo is not null");
            return (Criteria) this;
        }

        public Criteria andTaxnoEqualTo(String value) {
            addCriterion("TaxNo =", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotEqualTo(String value) {
            addCriterion("TaxNo <>", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThan(String value) {
            addCriterion("TaxNo >", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoGreaterThanOrEqualTo(String value) {
            addCriterion("TaxNo >=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThan(String value) {
            addCriterion("TaxNo <", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLessThanOrEqualTo(String value) {
            addCriterion("TaxNo <=", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoLike(String value) {
            addCriterion("TaxNo like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotLike(String value) {
            addCriterion("TaxNo not like", value, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoIn(List<String> values) {
            addCriterion("TaxNo in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotIn(List<String> values) {
            addCriterion("TaxNo not in", values, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoBetween(String value1, String value2) {
            addCriterion("TaxNo between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andTaxnoNotBetween(String value1, String value2) {
            addCriterion("TaxNo not between", value1, value2, "taxno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNull() {
            addCriterion("BankAccNo is null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIsNotNull() {
            addCriterion("BankAccNo is not null");
            return (Criteria) this;
        }

        public Criteria andBankaccnoEqualTo(String value) {
            addCriterion("BankAccNo =", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotEqualTo(String value) {
            addCriterion("BankAccNo <>", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThan(String value) {
            addCriterion("BankAccNo >", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoGreaterThanOrEqualTo(String value) {
            addCriterion("BankAccNo >=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThan(String value) {
            addCriterion("BankAccNo <", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLessThanOrEqualTo(String value) {
            addCriterion("BankAccNo <=", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoLike(String value) {
            addCriterion("BankAccNo like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotLike(String value) {
            addCriterion("BankAccNo not like", value, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoIn(List<String> values) {
            addCriterion("BankAccNo in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotIn(List<String> values) {
            addCriterion("BankAccNo not in", values, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoBetween(String value1, String value2) {
            addCriterion("BankAccNo between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankaccnoNotBetween(String value1, String value2) {
            addCriterion("BankAccNo not between", value1, value2, "bankaccno");
            return (Criteria) this;
        }

        public Criteria andBankIsNull() {
            addCriterion("Bank is null");
            return (Criteria) this;
        }

        public Criteria andBankIsNotNull() {
            addCriterion("Bank is not null");
            return (Criteria) this;
        }

        public Criteria andBankEqualTo(String value) {
            addCriterion("Bank =", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotEqualTo(String value) {
            addCriterion("Bank <>", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThan(String value) {
            addCriterion("Bank >", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankGreaterThanOrEqualTo(String value) {
            addCriterion("Bank >=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThan(String value) {
            addCriterion("Bank <", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLessThanOrEqualTo(String value) {
            addCriterion("Bank <=", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankLike(String value) {
            addCriterion("Bank like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotLike(String value) {
            addCriterion("Bank not like", value, "bank");
            return (Criteria) this;
        }

        public Criteria andBankIn(List<String> values) {
            addCriterion("Bank in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotIn(List<String> values) {
            addCriterion("Bank not in", values, "bank");
            return (Criteria) this;
        }

        public Criteria andBankBetween(String value1, String value2) {
            addCriterion("Bank between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andBankNotBetween(String value1, String value2) {
            addCriterion("Bank not between", value1, value2, "bank");
            return (Criteria) this;
        }

        public Criteria andDistrateIsNull() {
            addCriterion("DistRate is null");
            return (Criteria) this;
        }

        public Criteria andDistrateIsNotNull() {
            addCriterion("DistRate is not null");
            return (Criteria) this;
        }

        public Criteria andDistrateEqualTo(BigDecimal value) {
            addCriterion("DistRate =", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotEqualTo(BigDecimal value) {
            addCriterion("DistRate <>", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateGreaterThan(BigDecimal value) {
            addCriterion("DistRate >", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DistRate >=", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateLessThan(BigDecimal value) {
            addCriterion("DistRate <", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DistRate <=", value, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateIn(List<BigDecimal> values) {
            addCriterion("DistRate in", values, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotIn(List<BigDecimal> values) {
            addCriterion("DistRate not in", values, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistRate between", value1, value2, "distrate");
            return (Criteria) this;
        }

        public Criteria andDistrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DistRate not between", value1, value2, "distrate");
            return (Criteria) this;
        }

        public Criteria andWspriceIsNull() {
            addCriterion("WSPrice is null");
            return (Criteria) this;
        }

        public Criteria andWspriceIsNotNull() {
            addCriterion("WSPrice is not null");
            return (Criteria) this;
        }

        public Criteria andWspriceEqualTo(String value) {
            addCriterion("WSPrice =", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotEqualTo(String value) {
            addCriterion("WSPrice <>", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceGreaterThan(String value) {
            addCriterion("WSPrice >", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceGreaterThanOrEqualTo(String value) {
            addCriterion("WSPrice >=", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceLessThan(String value) {
            addCriterion("WSPrice <", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceLessThanOrEqualTo(String value) {
            addCriterion("WSPrice <=", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceLike(String value) {
            addCriterion("WSPrice like", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotLike(String value) {
            addCriterion("WSPrice not like", value, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceIn(List<String> values) {
            addCriterion("WSPrice in", values, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotIn(List<String> values) {
            addCriterion("WSPrice not in", values, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceBetween(String value1, String value2) {
            addCriterion("WSPrice between", value1, value2, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWspriceNotBetween(String value1, String value2) {
            addCriterion("WSPrice not between", value1, value2, "wsprice");
            return (Criteria) this;
        }

        public Criteria andWsdiscIsNull() {
            addCriterion("WSDisc is null");
            return (Criteria) this;
        }

        public Criteria andWsdiscIsNotNull() {
            addCriterion("WSDisc is not null");
            return (Criteria) this;
        }

        public Criteria andWsdiscEqualTo(BigDecimal value) {
            addCriterion("WSDisc =", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotEqualTo(BigDecimal value) {
            addCriterion("WSDisc <>", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscGreaterThan(BigDecimal value) {
            addCriterion("WSDisc >", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WSDisc >=", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscLessThan(BigDecimal value) {
            addCriterion("WSDisc <", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WSDisc <=", value, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscIn(List<BigDecimal> values) {
            addCriterion("WSDisc in", values, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotIn(List<BigDecimal> values) {
            addCriterion("WSDisc not in", values, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSDisc between", value1, value2, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWsdiscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSDisc not between", value1, value2, "wsdisc");
            return (Criteria) this;
        }

        public Criteria andWscreditIsNull() {
            addCriterion("WSCredit is null");
            return (Criteria) this;
        }

        public Criteria andWscreditIsNotNull() {
            addCriterion("WSCredit is not null");
            return (Criteria) this;
        }

        public Criteria andWscreditEqualTo(BigDecimal value) {
            addCriterion("WSCredit =", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditNotEqualTo(BigDecimal value) {
            addCriterion("WSCredit <>", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditGreaterThan(BigDecimal value) {
            addCriterion("WSCredit >", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WSCredit >=", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditLessThan(BigDecimal value) {
            addCriterion("WSCredit <", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WSCredit <=", value, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditIn(List<BigDecimal> values) {
            addCriterion("WSCredit in", values, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditNotIn(List<BigDecimal> values) {
            addCriterion("WSCredit not in", values, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSCredit between", value1, value2, "wscredit");
            return (Criteria) this;
        }

        public Criteria andWscreditNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WSCredit not between", value1, value2, "wscredit");
            return (Criteria) this;
        }

        public Criteria andAbandondateIsNull() {
            addCriterion("AbandonDate is null");
            return (Criteria) this;
        }

        public Criteria andAbandondateIsNotNull() {
            addCriterion("AbandonDate is not null");
            return (Criteria) this;
        }

        public Criteria andAbandondateEqualTo(Date value) {
            addCriterion("AbandonDate =", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotEqualTo(Date value) {
            addCriterion("AbandonDate <>", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateGreaterThan(Date value) {
            addCriterion("AbandonDate >", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateGreaterThanOrEqualTo(Date value) {
            addCriterion("AbandonDate >=", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateLessThan(Date value) {
            addCriterion("AbandonDate <", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateLessThanOrEqualTo(Date value) {
            addCriterion("AbandonDate <=", value, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateIn(List<Date> values) {
            addCriterion("AbandonDate in", values, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotIn(List<Date> values) {
            addCriterion("AbandonDate not in", values, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateBetween(Date value1, Date value2) {
            addCriterion("AbandonDate between", value1, value2, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandondateNotBetween(Date value1, Date value2) {
            addCriterion("AbandonDate not between", value1, value2, "abandondate");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIsNull() {
            addCriterion("AbandonWhys is null");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIsNotNull() {
            addCriterion("AbandonWhys is not null");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysEqualTo(String value) {
            addCriterion("AbandonWhys =", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotEqualTo(String value) {
            addCriterion("AbandonWhys <>", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysGreaterThan(String value) {
            addCriterion("AbandonWhys >", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysGreaterThanOrEqualTo(String value) {
            addCriterion("AbandonWhys >=", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLessThan(String value) {
            addCriterion("AbandonWhys <", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLessThanOrEqualTo(String value) {
            addCriterion("AbandonWhys <=", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysLike(String value) {
            addCriterion("AbandonWhys like", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotLike(String value) {
            addCriterion("AbandonWhys not like", value, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysIn(List<String> values) {
            addCriterion("AbandonWhys in", values, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotIn(List<String> values) {
            addCriterion("AbandonWhys not in", values, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysBetween(String value1, String value2) {
            addCriterion("AbandonWhys between", value1, value2, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andAbandonwhysNotBetween(String value1, String value2) {
            addCriterion("AbandonWhys not between", value1, value2, "abandonwhys");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNull() {
            addCriterion("BeginDate is null");
            return (Criteria) this;
        }

        public Criteria andBegindateIsNotNull() {
            addCriterion("BeginDate is not null");
            return (Criteria) this;
        }

        public Criteria andBegindateEqualTo(Date value) {
            addCriterion("BeginDate =", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotEqualTo(Date value) {
            addCriterion("BeginDate <>", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThan(Date value) {
            addCriterion("BeginDate >", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateGreaterThanOrEqualTo(Date value) {
            addCriterion("BeginDate >=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThan(Date value) {
            addCriterion("BeginDate <", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateLessThanOrEqualTo(Date value) {
            addCriterion("BeginDate <=", value, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateIn(List<Date> values) {
            addCriterion("BeginDate in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotIn(List<Date> values) {
            addCriterion("BeginDate not in", values, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateBetween(Date value1, Date value2) {
            addCriterion("BeginDate between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andBegindateNotBetween(Date value1, Date value2) {
            addCriterion("BeginDate not between", value1, value2, "begindate");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNull() {
            addCriterion("EndDate is null");
            return (Criteria) this;
        }

        public Criteria andEnddateIsNotNull() {
            addCriterion("EndDate is not null");
            return (Criteria) this;
        }

        public Criteria andEnddateEqualTo(Date value) {
            addCriterion("EndDate =", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotEqualTo(Date value) {
            addCriterion("EndDate <>", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThan(Date value) {
            addCriterion("EndDate >", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateGreaterThanOrEqualTo(Date value) {
            addCriterion("EndDate >=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThan(Date value) {
            addCriterion("EndDate <", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateLessThanOrEqualTo(Date value) {
            addCriterion("EndDate <=", value, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateIn(List<Date> values) {
            addCriterion("EndDate in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotIn(List<Date> values) {
            addCriterion("EndDate not in", values, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateBetween(Date value1, Date value2) {
            addCriterion("EndDate between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andEnddateNotBetween(Date value1, Date value2) {
            addCriterion("EndDate not between", value1, value2, "enddate");
            return (Criteria) this;
        }

        public Criteria andBalancecycIsNull() {
            addCriterion("BalanceCyc is null");
            return (Criteria) this;
        }

        public Criteria andBalancecycIsNotNull() {
            addCriterion("BalanceCyc is not null");
            return (Criteria) this;
        }

        public Criteria andBalancecycEqualTo(Integer value) {
            addCriterion("BalanceCyc =", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotEqualTo(Integer value) {
            addCriterion("BalanceCyc <>", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycGreaterThan(Integer value) {
            addCriterion("BalanceCyc >", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycGreaterThanOrEqualTo(Integer value) {
            addCriterion("BalanceCyc >=", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycLessThan(Integer value) {
            addCriterion("BalanceCyc <", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycLessThanOrEqualTo(Integer value) {
            addCriterion("BalanceCyc <=", value, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycIn(List<Integer> values) {
            addCriterion("BalanceCyc in", values, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotIn(List<Integer> values) {
            addCriterion("BalanceCyc not in", values, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycBetween(Integer value1, Integer value2) {
            addCriterion("BalanceCyc between", value1, value2, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancecycNotBetween(Integer value1, Integer value2) {
            addCriterion("BalanceCyc not between", value1, value2, "balancecyc");
            return (Criteria) this;
        }

        public Criteria andBalancemodeIsNull() {
            addCriterion("BalanceMode is null");
            return (Criteria) this;
        }

        public Criteria andBalancemodeIsNotNull() {
            addCriterion("BalanceMode is not null");
            return (Criteria) this;
        }

        public Criteria andBalancemodeEqualTo(String value) {
            addCriterion("BalanceMode =", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeNotEqualTo(String value) {
            addCriterion("BalanceMode <>", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeGreaterThan(String value) {
            addCriterion("BalanceMode >", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceMode >=", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeLessThan(String value) {
            addCriterion("BalanceMode <", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeLessThanOrEqualTo(String value) {
            addCriterion("BalanceMode <=", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeLike(String value) {
            addCriterion("BalanceMode like", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeNotLike(String value) {
            addCriterion("BalanceMode not like", value, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeIn(List<String> values) {
            addCriterion("BalanceMode in", values, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeNotIn(List<String> values) {
            addCriterion("BalanceMode not in", values, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeBetween(String value1, String value2) {
            addCriterion("BalanceMode between", value1, value2, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancemodeNotBetween(String value1, String value2) {
            addCriterion("BalanceMode not between", value1, value2, "balancemode");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIsNull() {
            addCriterion("BalanceType is null");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIsNotNull() {
            addCriterion("BalanceType is not null");
            return (Criteria) this;
        }

        public Criteria andBalancetypeEqualTo(String value) {
            addCriterion("BalanceType =", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotEqualTo(String value) {
            addCriterion("BalanceType <>", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeGreaterThan(String value) {
            addCriterion("BalanceType >", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeGreaterThanOrEqualTo(String value) {
            addCriterion("BalanceType >=", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLessThan(String value) {
            addCriterion("BalanceType <", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLessThanOrEqualTo(String value) {
            addCriterion("BalanceType <=", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeLike(String value) {
            addCriterion("BalanceType like", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotLike(String value) {
            addCriterion("BalanceType not like", value, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeIn(List<String> values) {
            addCriterion("BalanceType in", values, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotIn(List<String> values) {
            addCriterion("BalanceType not in", values, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeBetween(String value1, String value2) {
            addCriterion("BalanceType between", value1, value2, "balancetype");
            return (Criteria) this;
        }

        public Criteria andBalancetypeNotBetween(String value1, String value2) {
            addCriterion("BalanceType not between", value1, value2, "balancetype");
            return (Criteria) this;
        }

        public Criteria andClientrankIsNull() {
            addCriterion("ClientRank is null");
            return (Criteria) this;
        }

        public Criteria andClientrankIsNotNull() {
            addCriterion("ClientRank is not null");
            return (Criteria) this;
        }

        public Criteria andClientrankEqualTo(String value) {
            addCriterion("ClientRank =", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankNotEqualTo(String value) {
            addCriterion("ClientRank <>", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankGreaterThan(String value) {
            addCriterion("ClientRank >", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankGreaterThanOrEqualTo(String value) {
            addCriterion("ClientRank >=", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankLessThan(String value) {
            addCriterion("ClientRank <", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankLessThanOrEqualTo(String value) {
            addCriterion("ClientRank <=", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankLike(String value) {
            addCriterion("ClientRank like", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankNotLike(String value) {
            addCriterion("ClientRank not like", value, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankIn(List<String> values) {
            addCriterion("ClientRank in", values, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankNotIn(List<String> values) {
            addCriterion("ClientRank not in", values, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankBetween(String value1, String value2) {
            addCriterion("ClientRank between", value1, value2, "clientrank");
            return (Criteria) this;
        }

        public Criteria andClientrankNotBetween(String value1, String value2) {
            addCriterion("ClientRank not between", value1, value2, "clientrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankIsNull() {
            addCriterion("OfferRank is null");
            return (Criteria) this;
        }

        public Criteria andOfferrankIsNotNull() {
            addCriterion("OfferRank is not null");
            return (Criteria) this;
        }

        public Criteria andOfferrankEqualTo(Integer value) {
            addCriterion("OfferRank =", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotEqualTo(Integer value) {
            addCriterion("OfferRank <>", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankGreaterThan(Integer value) {
            addCriterion("OfferRank >", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankGreaterThanOrEqualTo(Integer value) {
            addCriterion("OfferRank >=", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankLessThan(Integer value) {
            addCriterion("OfferRank <", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankLessThanOrEqualTo(Integer value) {
            addCriterion("OfferRank <=", value, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankIn(List<Integer> values) {
            addCriterion("OfferRank in", values, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotIn(List<Integer> values) {
            addCriterion("OfferRank not in", values, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankBetween(Integer value1, Integer value2) {
            addCriterion("OfferRank between", value1, value2, "offerrank");
            return (Criteria) this;
        }

        public Criteria andOfferrankNotBetween(Integer value1, Integer value2) {
            addCriterion("OfferRank not between", value1, value2, "offerrank");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNull() {
            addCriterion("Business is null");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNotNull() {
            addCriterion("Business is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessEqualTo(String value) {
            addCriterion("Business =", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotEqualTo(String value) {
            addCriterion("Business <>", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThan(String value) {
            addCriterion("Business >", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThanOrEqualTo(String value) {
            addCriterion("Business >=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThan(String value) {
            addCriterion("Business <", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThanOrEqualTo(String value) {
            addCriterion("Business <=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLike(String value) {
            addCriterion("Business like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotLike(String value) {
            addCriterion("Business not like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessIn(List<String> values) {
            addCriterion("Business in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotIn(List<String> values) {
            addCriterion("Business not in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessBetween(String value1, String value2) {
            addCriterion("Business between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotBetween(String value1, String value2) {
            addCriterion("Business not between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("Status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("Status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("Status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("Status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("Status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("Status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("Status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("Status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("Status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("Status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("Status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("Status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("Status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("Status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andLineIsNull() {
            addCriterion("Line is null");
            return (Criteria) this;
        }

        public Criteria andLineIsNotNull() {
            addCriterion("Line is not null");
            return (Criteria) this;
        }

        public Criteria andLineEqualTo(String value) {
            addCriterion("Line =", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineNotEqualTo(String value) {
            addCriterion("Line <>", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineGreaterThan(String value) {
            addCriterion("Line >", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineGreaterThanOrEqualTo(String value) {
            addCriterion("Line >=", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineLessThan(String value) {
            addCriterion("Line <", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineLessThanOrEqualTo(String value) {
            addCriterion("Line <=", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineLike(String value) {
            addCriterion("Line like", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineNotLike(String value) {
            addCriterion("Line not like", value, "line");
            return (Criteria) this;
        }

        public Criteria andLineIn(List<String> values) {
            addCriterion("Line in", values, "line");
            return (Criteria) this;
        }

        public Criteria andLineNotIn(List<String> values) {
            addCriterion("Line not in", values, "line");
            return (Criteria) this;
        }

        public Criteria andLineBetween(String value1, String value2) {
            addCriterion("Line between", value1, value2, "line");
            return (Criteria) this;
        }

        public Criteria andLineNotBetween(String value1, String value2) {
            addCriterion("Line not between", value1, value2, "line");
            return (Criteria) this;
        }

        public Criteria andLineseqIsNull() {
            addCriterion("LineSEQ is null");
            return (Criteria) this;
        }

        public Criteria andLineseqIsNotNull() {
            addCriterion("LineSEQ is not null");
            return (Criteria) this;
        }

        public Criteria andLineseqEqualTo(Integer value) {
            addCriterion("LineSEQ =", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqNotEqualTo(Integer value) {
            addCriterion("LineSEQ <>", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqGreaterThan(Integer value) {
            addCriterion("LineSEQ >", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqGreaterThanOrEqualTo(Integer value) {
            addCriterion("LineSEQ >=", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqLessThan(Integer value) {
            addCriterion("LineSEQ <", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqLessThanOrEqualTo(Integer value) {
            addCriterion("LineSEQ <=", value, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqIn(List<Integer> values) {
            addCriterion("LineSEQ in", values, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqNotIn(List<Integer> values) {
            addCriterion("LineSEQ not in", values, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqBetween(Integer value1, Integer value2) {
            addCriterion("LineSEQ between", value1, value2, "lineseq");
            return (Criteria) this;
        }

        public Criteria andLineseqNotBetween(Integer value1, Integer value2) {
            addCriterion("LineSEQ not between", value1, value2, "lineseq");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNull() {
            addCriterion("NewUpdate is null");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNotNull() {
            addCriterion("NewUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andNewupdateEqualTo(Date value) {
            addCriterion("NewUpdate =", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotEqualTo(Date value) {
            addCriterion("NewUpdate <>", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThan(Date value) {
            addCriterion("NewUpdate >", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewUpdate >=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThan(Date value) {
            addCriterion("NewUpdate <", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThanOrEqualTo(Date value) {
            addCriterion("NewUpdate <=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateIn(List<Date> values) {
            addCriterion("NewUpdate in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotIn(List<Date> values) {
            addCriterion("NewUpdate not in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateBetween(Date value1, Date value2) {
            addCriterion("NewUpdate between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotBetween(Date value1, Date value2) {
            addCriterion("NewUpdate not between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andFareaeraIsNull() {
            addCriterion("FareAera is null");
            return (Criteria) this;
        }

        public Criteria andFareaeraIsNotNull() {
            addCriterion("FareAera is not null");
            return (Criteria) this;
        }

        public Criteria andFareaeraEqualTo(Integer value) {
            addCriterion("FareAera =", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraNotEqualTo(Integer value) {
            addCriterion("FareAera <>", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraGreaterThan(Integer value) {
            addCriterion("FareAera >", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraGreaterThanOrEqualTo(Integer value) {
            addCriterion("FareAera >=", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraLessThan(Integer value) {
            addCriterion("FareAera <", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraLessThanOrEqualTo(Integer value) {
            addCriterion("FareAera <=", value, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraIn(List<Integer> values) {
            addCriterion("FareAera in", values, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraNotIn(List<Integer> values) {
            addCriterion("FareAera not in", values, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraBetween(Integer value1, Integer value2) {
            addCriterion("FareAera between", value1, value2, "fareaera");
            return (Criteria) this;
        }

        public Criteria andFareaeraNotBetween(Integer value1, Integer value2) {
            addCriterion("FareAera not between", value1, value2, "fareaera");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtIsNull() {
            addCriterion("MonSaleAmt is null");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtIsNotNull() {
            addCriterion("MonSaleAmt is not null");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtEqualTo(BigDecimal value) {
            addCriterion("MonSaleAmt =", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtNotEqualTo(BigDecimal value) {
            addCriterion("MonSaleAmt <>", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtGreaterThan(BigDecimal value) {
            addCriterion("MonSaleAmt >", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MonSaleAmt >=", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtLessThan(BigDecimal value) {
            addCriterion("MonSaleAmt <", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MonSaleAmt <=", value, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtIn(List<BigDecimal> values) {
            addCriterion("MonSaleAmt in", values, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtNotIn(List<BigDecimal> values) {
            addCriterion("MonSaleAmt not in", values, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MonSaleAmt between", value1, value2, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMonsaleamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MonSaleAmt not between", value1, value2, "monsaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtIsNull() {
            addCriterion("MySaleAmt is null");
            return (Criteria) this;
        }

        public Criteria andMysaleamtIsNotNull() {
            addCriterion("MySaleAmt is not null");
            return (Criteria) this;
        }

        public Criteria andMysaleamtEqualTo(BigDecimal value) {
            addCriterion("MySaleAmt =", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtNotEqualTo(BigDecimal value) {
            addCriterion("MySaleAmt <>", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtGreaterThan(BigDecimal value) {
            addCriterion("MySaleAmt >", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MySaleAmt >=", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtLessThan(BigDecimal value) {
            addCriterion("MySaleAmt <", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MySaleAmt <=", value, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtIn(List<BigDecimal> values) {
            addCriterion("MySaleAmt in", values, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtNotIn(List<BigDecimal> values) {
            addCriterion("MySaleAmt not in", values, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MySaleAmt between", value1, value2, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andMysaleamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MySaleAmt not between", value1, value2, "mysaleamt");
            return (Criteria) this;
        }

        public Criteria andAccepttimeIsNull() {
            addCriterion("AcceptTime is null");
            return (Criteria) this;
        }

        public Criteria andAccepttimeIsNotNull() {
            addCriterion("AcceptTime is not null");
            return (Criteria) this;
        }

        public Criteria andAccepttimeEqualTo(Date value) {
            addCriterion("AcceptTime =", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeNotEqualTo(Date value) {
            addCriterion("AcceptTime <>", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeGreaterThan(Date value) {
            addCriterion("AcceptTime >", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("AcceptTime >=", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeLessThan(Date value) {
            addCriterion("AcceptTime <", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeLessThanOrEqualTo(Date value) {
            addCriterion("AcceptTime <=", value, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeIn(List<Date> values) {
            addCriterion("AcceptTime in", values, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeNotIn(List<Date> values) {
            addCriterion("AcceptTime not in", values, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeBetween(Date value1, Date value2) {
            addCriterion("AcceptTime between", value1, value2, "accepttime");
            return (Criteria) this;
        }

        public Criteria andAccepttimeNotBetween(Date value1, Date value2) {
            addCriterion("AcceptTime not between", value1, value2, "accepttime");
            return (Criteria) this;
        }

        public Criteria andOutcontractIsNull() {
            addCriterion("OutContract is null");
            return (Criteria) this;
        }

        public Criteria andOutcontractIsNotNull() {
            addCriterion("OutContract is not null");
            return (Criteria) this;
        }

        public Criteria andOutcontractEqualTo(String value) {
            addCriterion("OutContract =", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotEqualTo(String value) {
            addCriterion("OutContract <>", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractGreaterThan(String value) {
            addCriterion("OutContract >", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractGreaterThanOrEqualTo(String value) {
            addCriterion("OutContract >=", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLessThan(String value) {
            addCriterion("OutContract <", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLessThanOrEqualTo(String value) {
            addCriterion("OutContract <=", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractLike(String value) {
            addCriterion("OutContract like", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotLike(String value) {
            addCriterion("OutContract not like", value, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractIn(List<String> values) {
            addCriterion("OutContract in", values, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotIn(List<String> values) {
            addCriterion("OutContract not in", values, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractBetween(String value1, String value2) {
            addCriterion("OutContract between", value1, value2, "outcontract");
            return (Criteria) this;
        }

        public Criteria andOutcontractNotBetween(String value1, String value2) {
            addCriterion("OutContract not between", value1, value2, "outcontract");
            return (Criteria) this;
        }

        public Criteria andPrepromotionIsNull() {
            addCriterion("PrePromotion is null");
            return (Criteria) this;
        }

        public Criteria andPrepromotionIsNotNull() {
            addCriterion("PrePromotion is not null");
            return (Criteria) this;
        }

        public Criteria andPrepromotionEqualTo(Integer value) {
            addCriterion("PrePromotion =", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionNotEqualTo(Integer value) {
            addCriterion("PrePromotion <>", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionGreaterThan(Integer value) {
            addCriterion("PrePromotion >", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionGreaterThanOrEqualTo(Integer value) {
            addCriterion("PrePromotion >=", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionLessThan(Integer value) {
            addCriterion("PrePromotion <", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionLessThanOrEqualTo(Integer value) {
            addCriterion("PrePromotion <=", value, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionIn(List<Integer> values) {
            addCriterion("PrePromotion in", values, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionNotIn(List<Integer> values) {
            addCriterion("PrePromotion not in", values, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionBetween(Integer value1, Integer value2) {
            addCriterion("PrePromotion between", value1, value2, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPrepromotionNotBetween(Integer value1, Integer value2) {
            addCriterion("PrePromotion not between", value1, value2, "prepromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionIsNull() {
            addCriterion("PostPromotion is null");
            return (Criteria) this;
        }

        public Criteria andPostpromotionIsNotNull() {
            addCriterion("PostPromotion is not null");
            return (Criteria) this;
        }

        public Criteria andPostpromotionEqualTo(Integer value) {
            addCriterion("PostPromotion =", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionNotEqualTo(Integer value) {
            addCriterion("PostPromotion <>", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionGreaterThan(Integer value) {
            addCriterion("PostPromotion >", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionGreaterThanOrEqualTo(Integer value) {
            addCriterion("PostPromotion >=", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionLessThan(Integer value) {
            addCriterion("PostPromotion <", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionLessThanOrEqualTo(Integer value) {
            addCriterion("PostPromotion <=", value, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionIn(List<Integer> values) {
            addCriterion("PostPromotion in", values, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionNotIn(List<Integer> values) {
            addCriterion("PostPromotion not in", values, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionBetween(Integer value1, Integer value2) {
            addCriterion("PostPromotion between", value1, value2, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andPostpromotionNotBetween(Integer value1, Integer value2) {
            addCriterion("PostPromotion not between", value1, value2, "postpromotion");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIsNull() {
            addCriterion("RebateMode is null");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIsNotNull() {
            addCriterion("RebateMode is not null");
            return (Criteria) this;
        }

        public Criteria andRebatemodeEqualTo(String value) {
            addCriterion("RebateMode =", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotEqualTo(String value) {
            addCriterion("RebateMode <>", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeGreaterThan(String value) {
            addCriterion("RebateMode >", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeGreaterThanOrEqualTo(String value) {
            addCriterion("RebateMode >=", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLessThan(String value) {
            addCriterion("RebateMode <", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLessThanOrEqualTo(String value) {
            addCriterion("RebateMode <=", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeLike(String value) {
            addCriterion("RebateMode like", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotLike(String value) {
            addCriterion("RebateMode not like", value, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeIn(List<String> values) {
            addCriterion("RebateMode in", values, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotIn(List<String> values) {
            addCriterion("RebateMode not in", values, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeBetween(String value1, String value2) {
            addCriterion("RebateMode between", value1, value2, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebatemodeNotBetween(String value1, String value2) {
            addCriterion("RebateMode not between", value1, value2, "rebatemode");
            return (Criteria) this;
        }

        public Criteria andRebateIsNull() {
            addCriterion("Rebate is null");
            return (Criteria) this;
        }

        public Criteria andRebateIsNotNull() {
            addCriterion("Rebate is not null");
            return (Criteria) this;
        }

        public Criteria andRebateEqualTo(BigDecimal value) {
            addCriterion("Rebate =", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotEqualTo(BigDecimal value) {
            addCriterion("Rebate <>", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThan(BigDecimal value) {
            addCriterion("Rebate >", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate >=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThan(BigDecimal value) {
            addCriterion("Rebate <", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate <=", value, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateIn(List<BigDecimal> values) {
            addCriterion("Rebate in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotIn(List<BigDecimal> values) {
            addCriterion("Rebate not in", values, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate not between", value1, value2, "rebate");
            return (Criteria) this;
        }

        public Criteria andRebatecondIsNull() {
            addCriterion("RebateCond is null");
            return (Criteria) this;
        }

        public Criteria andRebatecondIsNotNull() {
            addCriterion("RebateCond is not null");
            return (Criteria) this;
        }

        public Criteria andRebatecondEqualTo(BigDecimal value) {
            addCriterion("RebateCond =", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotEqualTo(BigDecimal value) {
            addCriterion("RebateCond <>", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondGreaterThan(BigDecimal value) {
            addCriterion("RebateCond >", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateCond >=", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondLessThan(BigDecimal value) {
            addCriterion("RebateCond <", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RebateCond <=", value, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondIn(List<BigDecimal> values) {
            addCriterion("RebateCond in", values, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotIn(List<BigDecimal> values) {
            addCriterion("RebateCond not in", values, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateCond between", value1, value2, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebatecondNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RebateCond not between", value1, value2, "rebatecond");
            return (Criteria) this;
        }

        public Criteria andRebate2IsNull() {
            addCriterion("Rebate2 is null");
            return (Criteria) this;
        }

        public Criteria andRebate2IsNotNull() {
            addCriterion("Rebate2 is not null");
            return (Criteria) this;
        }

        public Criteria andRebate2EqualTo(BigDecimal value) {
            addCriterion("Rebate2 =", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotEqualTo(BigDecimal value) {
            addCriterion("Rebate2 <>", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2GreaterThan(BigDecimal value) {
            addCriterion("Rebate2 >", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate2 >=", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2LessThan(BigDecimal value) {
            addCriterion("Rebate2 <", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Rebate2 <=", value, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2In(List<BigDecimal> values) {
            addCriterion("Rebate2 in", values, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotIn(List<BigDecimal> values) {
            addCriterion("Rebate2 not in", values, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate2 between", value1, value2, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebate2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Rebate2 not between", value1, value2, "rebate2");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIsNull() {
            addCriterion("RebatePayMode is null");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIsNotNull() {
            addCriterion("RebatePayMode is not null");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeEqualTo(String value) {
            addCriterion("RebatePayMode =", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotEqualTo(String value) {
            addCriterion("RebatePayMode <>", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeGreaterThan(String value) {
            addCriterion("RebatePayMode >", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeGreaterThanOrEqualTo(String value) {
            addCriterion("RebatePayMode >=", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLessThan(String value) {
            addCriterion("RebatePayMode <", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLessThanOrEqualTo(String value) {
            addCriterion("RebatePayMode <=", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeLike(String value) {
            addCriterion("RebatePayMode like", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotLike(String value) {
            addCriterion("RebatePayMode not like", value, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeIn(List<String> values) {
            addCriterion("RebatePayMode in", values, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotIn(List<String> values) {
            addCriterion("RebatePayMode not in", values, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeBetween(String value1, String value2) {
            addCriterion("RebatePayMode between", value1, value2, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andRebatepaymodeNotBetween(String value1, String value2) {
            addCriterion("RebatePayMode not between", value1, value2, "rebatepaymode");
            return (Criteria) this;
        }

        public Criteria andDelivercycIsNull() {
            addCriterion("DeliverCyc is null");
            return (Criteria) this;
        }

        public Criteria andDelivercycIsNotNull() {
            addCriterion("DeliverCyc is not null");
            return (Criteria) this;
        }

        public Criteria andDelivercycEqualTo(Integer value) {
            addCriterion("DeliverCyc =", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycNotEqualTo(Integer value) {
            addCriterion("DeliverCyc <>", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycGreaterThan(Integer value) {
            addCriterion("DeliverCyc >", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycGreaterThanOrEqualTo(Integer value) {
            addCriterion("DeliverCyc >=", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycLessThan(Integer value) {
            addCriterion("DeliverCyc <", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycLessThanOrEqualTo(Integer value) {
            addCriterion("DeliverCyc <=", value, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycIn(List<Integer> values) {
            addCriterion("DeliverCyc in", values, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycNotIn(List<Integer> values) {
            addCriterion("DeliverCyc not in", values, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycBetween(Integer value1, Integer value2) {
            addCriterion("DeliverCyc between", value1, value2, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andDelivercycNotBetween(Integer value1, Integer value2) {
            addCriterion("DeliverCyc not between", value1, value2, "delivercyc");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeIsNull() {
            addCriterion("ReceiveBTime is null");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeIsNotNull() {
            addCriterion("ReceiveBTime is not null");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeEqualTo(String value) {
            addCriterion("ReceiveBTime =", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeNotEqualTo(String value) {
            addCriterion("ReceiveBTime <>", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeGreaterThan(String value) {
            addCriterion("ReceiveBTime >", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiveBTime >=", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeLessThan(String value) {
            addCriterion("ReceiveBTime <", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeLessThanOrEqualTo(String value) {
            addCriterion("ReceiveBTime <=", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeLike(String value) {
            addCriterion("ReceiveBTime like", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeNotLike(String value) {
            addCriterion("ReceiveBTime not like", value, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeIn(List<String> values) {
            addCriterion("ReceiveBTime in", values, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeNotIn(List<String> values) {
            addCriterion("ReceiveBTime not in", values, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeBetween(String value1, String value2) {
            addCriterion("ReceiveBTime between", value1, value2, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceivebtimeNotBetween(String value1, String value2) {
            addCriterion("ReceiveBTime not between", value1, value2, "receivebtime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeIsNull() {
            addCriterion("ReceiveETime is null");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeIsNotNull() {
            addCriterion("ReceiveETime is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeEqualTo(String value) {
            addCriterion("ReceiveETime =", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeNotEqualTo(String value) {
            addCriterion("ReceiveETime <>", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeGreaterThan(String value) {
            addCriterion("ReceiveETime >", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiveETime >=", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeLessThan(String value) {
            addCriterion("ReceiveETime <", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeLessThanOrEqualTo(String value) {
            addCriterion("ReceiveETime <=", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeLike(String value) {
            addCriterion("ReceiveETime like", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeNotLike(String value) {
            addCriterion("ReceiveETime not like", value, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeIn(List<String> values) {
            addCriterion("ReceiveETime in", values, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeNotIn(List<String> values) {
            addCriterion("ReceiveETime not in", values, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeBetween(String value1, String value2) {
            addCriterion("ReceiveETime between", value1, value2, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andReceiveetimeNotBetween(String value1, String value2) {
            addCriterion("ReceiveETime not between", value1, value2, "receiveetime");
            return (Criteria) this;
        }

        public Criteria andEdimodeIsNull() {
            addCriterion("EDIMode is null");
            return (Criteria) this;
        }

        public Criteria andEdimodeIsNotNull() {
            addCriterion("EDIMode is not null");
            return (Criteria) this;
        }

        public Criteria andEdimodeEqualTo(String value) {
            addCriterion("EDIMode =", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotEqualTo(String value) {
            addCriterion("EDIMode <>", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeGreaterThan(String value) {
            addCriterion("EDIMode >", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeGreaterThanOrEqualTo(String value) {
            addCriterion("EDIMode >=", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLessThan(String value) {
            addCriterion("EDIMode <", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLessThanOrEqualTo(String value) {
            addCriterion("EDIMode <=", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeLike(String value) {
            addCriterion("EDIMode like", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotLike(String value) {
            addCriterion("EDIMode not like", value, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeIn(List<String> values) {
            addCriterion("EDIMode in", values, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotIn(List<String> values) {
            addCriterion("EDIMode not in", values, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeBetween(String value1, String value2) {
            addCriterion("EDIMode between", value1, value2, "edimode");
            return (Criteria) this;
        }

        public Criteria andEdimodeNotBetween(String value1, String value2) {
            addCriterion("EDIMode not between", value1, value2, "edimode");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("Password is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("Password is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("Password =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("Password <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("Password >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("Password >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("Password <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("Password <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("Password like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("Password not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("Password in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("Password not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("Password between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("Password not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andFee1IsNull() {
            addCriterion("Fee1 is null");
            return (Criteria) this;
        }

        public Criteria andFee1IsNotNull() {
            addCriterion("Fee1 is not null");
            return (Criteria) this;
        }

        public Criteria andFee1EqualTo(BigDecimal value) {
            addCriterion("Fee1 =", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotEqualTo(BigDecimal value) {
            addCriterion("Fee1 <>", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1GreaterThan(BigDecimal value) {
            addCriterion("Fee1 >", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee1 >=", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1LessThan(BigDecimal value) {
            addCriterion("Fee1 <", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee1 <=", value, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1In(List<BigDecimal> values) {
            addCriterion("Fee1 in", values, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotIn(List<BigDecimal> values) {
            addCriterion("Fee1 not in", values, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee1 between", value1, value2, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee1 not between", value1, value2, "fee1");
            return (Criteria) this;
        }

        public Criteria andFee2IsNull() {
            addCriterion("Fee2 is null");
            return (Criteria) this;
        }

        public Criteria andFee2IsNotNull() {
            addCriterion("Fee2 is not null");
            return (Criteria) this;
        }

        public Criteria andFee2EqualTo(BigDecimal value) {
            addCriterion("Fee2 =", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotEqualTo(BigDecimal value) {
            addCriterion("Fee2 <>", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2GreaterThan(BigDecimal value) {
            addCriterion("Fee2 >", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee2 >=", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2LessThan(BigDecimal value) {
            addCriterion("Fee2 <", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee2 <=", value, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2In(List<BigDecimal> values) {
            addCriterion("Fee2 in", values, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotIn(List<BigDecimal> values) {
            addCriterion("Fee2 not in", values, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee2 between", value1, value2, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee2 not between", value1, value2, "fee2");
            return (Criteria) this;
        }

        public Criteria andFee3IsNull() {
            addCriterion("Fee3 is null");
            return (Criteria) this;
        }

        public Criteria andFee3IsNotNull() {
            addCriterion("Fee3 is not null");
            return (Criteria) this;
        }

        public Criteria andFee3EqualTo(BigDecimal value) {
            addCriterion("Fee3 =", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotEqualTo(BigDecimal value) {
            addCriterion("Fee3 <>", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3GreaterThan(BigDecimal value) {
            addCriterion("Fee3 >", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee3 >=", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3LessThan(BigDecimal value) {
            addCriterion("Fee3 <", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee3 <=", value, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3In(List<BigDecimal> values) {
            addCriterion("Fee3 in", values, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotIn(List<BigDecimal> values) {
            addCriterion("Fee3 not in", values, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee3 between", value1, value2, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee3NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee3 not between", value1, value2, "fee3");
            return (Criteria) this;
        }

        public Criteria andFee4IsNull() {
            addCriterion("Fee4 is null");
            return (Criteria) this;
        }

        public Criteria andFee4IsNotNull() {
            addCriterion("Fee4 is not null");
            return (Criteria) this;
        }

        public Criteria andFee4EqualTo(BigDecimal value) {
            addCriterion("Fee4 =", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotEqualTo(BigDecimal value) {
            addCriterion("Fee4 <>", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4GreaterThan(BigDecimal value) {
            addCriterion("Fee4 >", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee4 >=", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4LessThan(BigDecimal value) {
            addCriterion("Fee4 <", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee4 <=", value, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4In(List<BigDecimal> values) {
            addCriterion("Fee4 in", values, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotIn(List<BigDecimal> values) {
            addCriterion("Fee4 not in", values, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee4 between", value1, value2, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee4 not between", value1, value2, "fee4");
            return (Criteria) this;
        }

        public Criteria andFee5IsNull() {
            addCriterion("Fee5 is null");
            return (Criteria) this;
        }

        public Criteria andFee5IsNotNull() {
            addCriterion("Fee5 is not null");
            return (Criteria) this;
        }

        public Criteria andFee5EqualTo(BigDecimal value) {
            addCriterion("Fee5 =", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotEqualTo(BigDecimal value) {
            addCriterion("Fee5 <>", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5GreaterThan(BigDecimal value) {
            addCriterion("Fee5 >", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee5 >=", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5LessThan(BigDecimal value) {
            addCriterion("Fee5 <", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee5 <=", value, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5In(List<BigDecimal> values) {
            addCriterion("Fee5 in", values, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotIn(List<BigDecimal> values) {
            addCriterion("Fee5 not in", values, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee5 between", value1, value2, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee5 not between", value1, value2, "fee5");
            return (Criteria) this;
        }

        public Criteria andFee6IsNull() {
            addCriterion("Fee6 is null");
            return (Criteria) this;
        }

        public Criteria andFee6IsNotNull() {
            addCriterion("Fee6 is not null");
            return (Criteria) this;
        }

        public Criteria andFee6EqualTo(BigDecimal value) {
            addCriterion("Fee6 =", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6NotEqualTo(BigDecimal value) {
            addCriterion("Fee6 <>", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6GreaterThan(BigDecimal value) {
            addCriterion("Fee6 >", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee6 >=", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6LessThan(BigDecimal value) {
            addCriterion("Fee6 <", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee6 <=", value, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6In(List<BigDecimal> values) {
            addCriterion("Fee6 in", values, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6NotIn(List<BigDecimal> values) {
            addCriterion("Fee6 not in", values, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee6 between", value1, value2, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee6NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee6 not between", value1, value2, "fee6");
            return (Criteria) this;
        }

        public Criteria andFee7IsNull() {
            addCriterion("Fee7 is null");
            return (Criteria) this;
        }

        public Criteria andFee7IsNotNull() {
            addCriterion("Fee7 is not null");
            return (Criteria) this;
        }

        public Criteria andFee7EqualTo(BigDecimal value) {
            addCriterion("Fee7 =", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7NotEqualTo(BigDecimal value) {
            addCriterion("Fee7 <>", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7GreaterThan(BigDecimal value) {
            addCriterion("Fee7 >", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee7 >=", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7LessThan(BigDecimal value) {
            addCriterion("Fee7 <", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee7 <=", value, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7In(List<BigDecimal> values) {
            addCriterion("Fee7 in", values, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7NotIn(List<BigDecimal> values) {
            addCriterion("Fee7 not in", values, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee7 between", value1, value2, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee7NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee7 not between", value1, value2, "fee7");
            return (Criteria) this;
        }

        public Criteria andFee8IsNull() {
            addCriterion("Fee8 is null");
            return (Criteria) this;
        }

        public Criteria andFee8IsNotNull() {
            addCriterion("Fee8 is not null");
            return (Criteria) this;
        }

        public Criteria andFee8EqualTo(BigDecimal value) {
            addCriterion("Fee8 =", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8NotEqualTo(BigDecimal value) {
            addCriterion("Fee8 <>", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8GreaterThan(BigDecimal value) {
            addCriterion("Fee8 >", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee8 >=", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8LessThan(BigDecimal value) {
            addCriterion("Fee8 <", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee8 <=", value, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8In(List<BigDecimal> values) {
            addCriterion("Fee8 in", values, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8NotIn(List<BigDecimal> values) {
            addCriterion("Fee8 not in", values, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee8 between", value1, value2, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee8NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee8 not between", value1, value2, "fee8");
            return (Criteria) this;
        }

        public Criteria andFee9IsNull() {
            addCriterion("Fee9 is null");
            return (Criteria) this;
        }

        public Criteria andFee9IsNotNull() {
            addCriterion("Fee9 is not null");
            return (Criteria) this;
        }

        public Criteria andFee9EqualTo(BigDecimal value) {
            addCriterion("Fee9 =", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9NotEqualTo(BigDecimal value) {
            addCriterion("Fee9 <>", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9GreaterThan(BigDecimal value) {
            addCriterion("Fee9 >", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee9 >=", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9LessThan(BigDecimal value) {
            addCriterion("Fee9 <", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee9 <=", value, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9In(List<BigDecimal> values) {
            addCriterion("Fee9 in", values, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9NotIn(List<BigDecimal> values) {
            addCriterion("Fee9 not in", values, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee9 between", value1, value2, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee9NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee9 not between", value1, value2, "fee9");
            return (Criteria) this;
        }

        public Criteria andFee10IsNull() {
            addCriterion("Fee10 is null");
            return (Criteria) this;
        }

        public Criteria andFee10IsNotNull() {
            addCriterion("Fee10 is not null");
            return (Criteria) this;
        }

        public Criteria andFee10EqualTo(BigDecimal value) {
            addCriterion("Fee10 =", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10NotEqualTo(BigDecimal value) {
            addCriterion("Fee10 <>", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10GreaterThan(BigDecimal value) {
            addCriterion("Fee10 >", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee10 >=", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10LessThan(BigDecimal value) {
            addCriterion("Fee10 <", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee10 <=", value, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10In(List<BigDecimal> values) {
            addCriterion("Fee10 in", values, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10NotIn(List<BigDecimal> values) {
            addCriterion("Fee10 not in", values, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee10 between", value1, value2, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee10NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee10 not between", value1, value2, "fee10");
            return (Criteria) this;
        }

        public Criteria andFee11IsNull() {
            addCriterion("Fee11 is null");
            return (Criteria) this;
        }

        public Criteria andFee11IsNotNull() {
            addCriterion("Fee11 is not null");
            return (Criteria) this;
        }

        public Criteria andFee11EqualTo(BigDecimal value) {
            addCriterion("Fee11 =", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11NotEqualTo(BigDecimal value) {
            addCriterion("Fee11 <>", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11GreaterThan(BigDecimal value) {
            addCriterion("Fee11 >", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee11 >=", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11LessThan(BigDecimal value) {
            addCriterion("Fee11 <", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee11 <=", value, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11In(List<BigDecimal> values) {
            addCriterion("Fee11 in", values, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11NotIn(List<BigDecimal> values) {
            addCriterion("Fee11 not in", values, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee11 between", value1, value2, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee11NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee11 not between", value1, value2, "fee11");
            return (Criteria) this;
        }

        public Criteria andFee12IsNull() {
            addCriterion("Fee12 is null");
            return (Criteria) this;
        }

        public Criteria andFee12IsNotNull() {
            addCriterion("Fee12 is not null");
            return (Criteria) this;
        }

        public Criteria andFee12EqualTo(BigDecimal value) {
            addCriterion("Fee12 =", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12NotEqualTo(BigDecimal value) {
            addCriterion("Fee12 <>", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12GreaterThan(BigDecimal value) {
            addCriterion("Fee12 >", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee12 >=", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12LessThan(BigDecimal value) {
            addCriterion("Fee12 <", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee12 <=", value, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12In(List<BigDecimal> values) {
            addCriterion("Fee12 in", values, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12NotIn(List<BigDecimal> values) {
            addCriterion("Fee12 not in", values, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee12 between", value1, value2, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee12NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee12 not between", value1, value2, "fee12");
            return (Criteria) this;
        }

        public Criteria andFee13IsNull() {
            addCriterion("Fee13 is null");
            return (Criteria) this;
        }

        public Criteria andFee13IsNotNull() {
            addCriterion("Fee13 is not null");
            return (Criteria) this;
        }

        public Criteria andFee13EqualTo(BigDecimal value) {
            addCriterion("Fee13 =", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13NotEqualTo(BigDecimal value) {
            addCriterion("Fee13 <>", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13GreaterThan(BigDecimal value) {
            addCriterion("Fee13 >", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee13 >=", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13LessThan(BigDecimal value) {
            addCriterion("Fee13 <", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13LessThanOrEqualTo(BigDecimal value) {
            addCriterion("Fee13 <=", value, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13In(List<BigDecimal> values) {
            addCriterion("Fee13 in", values, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13NotIn(List<BigDecimal> values) {
            addCriterion("Fee13 not in", values, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee13 between", value1, value2, "fee13");
            return (Criteria) this;
        }

        public Criteria andFee13NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Fee13 not between", value1, value2, "fee13");
            return (Criteria) this;
        }

        public Criteria andSystemflagIsNull() {
            addCriterion("SystemFlag is null");
            return (Criteria) this;
        }

        public Criteria andSystemflagIsNotNull() {
            addCriterion("SystemFlag is not null");
            return (Criteria) this;
        }

        public Criteria andSystemflagEqualTo(String value) {
            addCriterion("SystemFlag =", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagNotEqualTo(String value) {
            addCriterion("SystemFlag <>", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagGreaterThan(String value) {
            addCriterion("SystemFlag >", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagGreaterThanOrEqualTo(String value) {
            addCriterion("SystemFlag >=", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagLessThan(String value) {
            addCriterion("SystemFlag <", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagLessThanOrEqualTo(String value) {
            addCriterion("SystemFlag <=", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagLike(String value) {
            addCriterion("SystemFlag like", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagNotLike(String value) {
            addCriterion("SystemFlag not like", value, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagIn(List<String> values) {
            addCriterion("SystemFlag in", values, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagNotIn(List<String> values) {
            addCriterion("SystemFlag not in", values, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagBetween(String value1, String value2) {
            addCriterion("SystemFlag between", value1, value2, "systemflag");
            return (Criteria) this;
        }

        public Criteria andSystemflagNotBetween(String value1, String value2) {
            addCriterion("SystemFlag not between", value1, value2, "systemflag");
            return (Criteria) this;
        }

        public Criteria andAgreepriIsNull() {
            addCriterion("AgreePRI is null");
            return (Criteria) this;
        }

        public Criteria andAgreepriIsNotNull() {
            addCriterion("AgreePRI is not null");
            return (Criteria) this;
        }

        public Criteria andAgreepriEqualTo(String value) {
            addCriterion("AgreePRI =", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriNotEqualTo(String value) {
            addCriterion("AgreePRI <>", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriGreaterThan(String value) {
            addCriterion("AgreePRI >", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriGreaterThanOrEqualTo(String value) {
            addCriterion("AgreePRI >=", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriLessThan(String value) {
            addCriterion("AgreePRI <", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriLessThanOrEqualTo(String value) {
            addCriterion("AgreePRI <=", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriLike(String value) {
            addCriterion("AgreePRI like", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriNotLike(String value) {
            addCriterion("AgreePRI not like", value, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriIn(List<String> values) {
            addCriterion("AgreePRI in", values, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriNotIn(List<String> values) {
            addCriterion("AgreePRI not in", values, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriBetween(String value1, String value2) {
            addCriterion("AgreePRI between", value1, value2, "agreepri");
            return (Criteria) this;
        }

        public Criteria andAgreepriNotBetween(String value1, String value2) {
            addCriterion("AgreePRI not between", value1, value2, "agreepri");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("Operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("Operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(String value) {
            addCriterion("Operator =", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotEqualTo(String value) {
            addCriterion("Operator <>", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThan(String value) {
            addCriterion("Operator >", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThanOrEqualTo(String value) {
            addCriterion("Operator >=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThan(String value) {
            addCriterion("Operator <", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThanOrEqualTo(String value) {
            addCriterion("Operator <=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLike(String value) {
            addCriterion("Operator like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotLike(String value) {
            addCriterion("Operator not like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorIn(List<String> values) {
            addCriterion("Operator in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotIn(List<String> values) {
            addCriterion("Operator not in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorBetween(String value1, String value2) {
            addCriterion("Operator between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotBetween(String value1, String value2) {
            addCriterion("Operator not between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andBalacycpostIsNull() {
            addCriterion("BalaCycPost is null");
            return (Criteria) this;
        }

        public Criteria andBalacycpostIsNotNull() {
            addCriterion("BalaCycPost is not null");
            return (Criteria) this;
        }

        public Criteria andBalacycpostEqualTo(Integer value) {
            addCriterion("BalaCycPost =", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostNotEqualTo(Integer value) {
            addCriterion("BalaCycPost <>", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostGreaterThan(Integer value) {
            addCriterion("BalaCycPost >", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostGreaterThanOrEqualTo(Integer value) {
            addCriterion("BalaCycPost >=", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostLessThan(Integer value) {
            addCriterion("BalaCycPost <", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostLessThanOrEqualTo(Integer value) {
            addCriterion("BalaCycPost <=", value, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostIn(List<Integer> values) {
            addCriterion("BalaCycPost in", values, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostNotIn(List<Integer> values) {
            addCriterion("BalaCycPost not in", values, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostBetween(Integer value1, Integer value2) {
            addCriterion("BalaCycPost between", value1, value2, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andBalacycpostNotBetween(Integer value1, Integer value2) {
            addCriterion("BalaCycPost not between", value1, value2, "balacycpost");
            return (Criteria) this;
        }

        public Criteria andPricerateIsNull() {
            addCriterion("PriceRate is null");
            return (Criteria) this;
        }

        public Criteria andPricerateIsNotNull() {
            addCriterion("PriceRate is not null");
            return (Criteria) this;
        }

        public Criteria andPricerateEqualTo(BigDecimal value) {
            addCriterion("PriceRate =", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateNotEqualTo(BigDecimal value) {
            addCriterion("PriceRate <>", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateGreaterThan(BigDecimal value) {
            addCriterion("PriceRate >", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PriceRate >=", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateLessThan(BigDecimal value) {
            addCriterion("PriceRate <", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PriceRate <=", value, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateIn(List<BigDecimal> values) {
            addCriterion("PriceRate in", values, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateNotIn(List<BigDecimal> values) {
            addCriterion("PriceRate not in", values, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PriceRate between", value1, value2, "pricerate");
            return (Criteria) this;
        }

        public Criteria andPricerateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PriceRate not between", value1, value2, "pricerate");
            return (Criteria) this;
        }

        public Criteria andTransrateIsNull() {
            addCriterion("TransRate is null");
            return (Criteria) this;
        }

        public Criteria andTransrateIsNotNull() {
            addCriterion("TransRate is not null");
            return (Criteria) this;
        }

        public Criteria andTransrateEqualTo(BigDecimal value) {
            addCriterion("TransRate =", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateNotEqualTo(BigDecimal value) {
            addCriterion("TransRate <>", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateGreaterThan(BigDecimal value) {
            addCriterion("TransRate >", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TransRate >=", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateLessThan(BigDecimal value) {
            addCriterion("TransRate <", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TransRate <=", value, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateIn(List<BigDecimal> values) {
            addCriterion("TransRate in", values, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateNotIn(List<BigDecimal> values) {
            addCriterion("TransRate not in", values, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransRate between", value1, value2, "transrate");
            return (Criteria) this;
        }

        public Criteria andTransrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransRate not between", value1, value2, "transrate");
            return (Criteria) this;
        }

        public Criteria andInchecktypeIsNull() {
            addCriterion("InCheckType is null");
            return (Criteria) this;
        }

        public Criteria andInchecktypeIsNotNull() {
            addCriterion("InCheckType is not null");
            return (Criteria) this;
        }

        public Criteria andInchecktypeEqualTo(String value) {
            addCriterion("InCheckType =", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeNotEqualTo(String value) {
            addCriterion("InCheckType <>", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeGreaterThan(String value) {
            addCriterion("InCheckType >", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeGreaterThanOrEqualTo(String value) {
            addCriterion("InCheckType >=", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeLessThan(String value) {
            addCriterion("InCheckType <", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeLessThanOrEqualTo(String value) {
            addCriterion("InCheckType <=", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeLike(String value) {
            addCriterion("InCheckType like", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeNotLike(String value) {
            addCriterion("InCheckType not like", value, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeIn(List<String> values) {
            addCriterion("InCheckType in", values, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeNotIn(List<String> values) {
            addCriterion("InCheckType not in", values, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeBetween(String value1, String value2) {
            addCriterion("InCheckType between", value1, value2, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andInchecktypeNotBetween(String value1, String value2) {
            addCriterion("InCheckType not between", value1, value2, "inchecktype");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeIsNull() {
            addCriterion("OwnerCode is null");
            return (Criteria) this;
        }

        public Criteria andOwnercodeIsNotNull() {
            addCriterion("OwnerCode is not null");
            return (Criteria) this;
        }

        public Criteria andOwnercodeEqualTo(String value) {
            addCriterion("OwnerCode =", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeNotEqualTo(String value) {
            addCriterion("OwnerCode <>", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeGreaterThan(String value) {
            addCriterion("OwnerCode >", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeGreaterThanOrEqualTo(String value) {
            addCriterion("OwnerCode >=", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeLessThan(String value) {
            addCriterion("OwnerCode <", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeLessThanOrEqualTo(String value) {
            addCriterion("OwnerCode <=", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeLike(String value) {
            addCriterion("OwnerCode like", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeNotLike(String value) {
            addCriterion("OwnerCode not like", value, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeIn(List<String> values) {
            addCriterion("OwnerCode in", values, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeNotIn(List<String> values) {
            addCriterion("OwnerCode not in", values, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeBetween(String value1, String value2) {
            addCriterion("OwnerCode between", value1, value2, "ownercode");
            return (Criteria) this;
        }

        public Criteria andOwnercodeNotBetween(String value1, String value2) {
            addCriterion("OwnerCode not between", value1, value2, "ownercode");
            return (Criteria) this;
        }

        public Criteria andClientchannelIsNull() {
            addCriterion("ClientChannel is null");
            return (Criteria) this;
        }

        public Criteria andClientchannelIsNotNull() {
            addCriterion("ClientChannel is not null");
            return (Criteria) this;
        }

        public Criteria andClientchannelEqualTo(String value) {
            addCriterion("ClientChannel =", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelNotEqualTo(String value) {
            addCriterion("ClientChannel <>", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelGreaterThan(String value) {
            addCriterion("ClientChannel >", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelGreaterThanOrEqualTo(String value) {
            addCriterion("ClientChannel >=", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelLessThan(String value) {
            addCriterion("ClientChannel <", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelLessThanOrEqualTo(String value) {
            addCriterion("ClientChannel <=", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelLike(String value) {
            addCriterion("ClientChannel like", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelNotLike(String value) {
            addCriterion("ClientChannel not like", value, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelIn(List<String> values) {
            addCriterion("ClientChannel in", values, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelNotIn(List<String> values) {
            addCriterion("ClientChannel not in", values, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelBetween(String value1, String value2) {
            addCriterion("ClientChannel between", value1, value2, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andClientchannelNotBetween(String value1, String value2) {
            addCriterion("ClientChannel not between", value1, value2, "clientchannel");
            return (Criteria) this;
        }

        public Criteria andExcessrateIsNull() {
            addCriterion("ExcessRate is null");
            return (Criteria) this;
        }

        public Criteria andExcessrateIsNotNull() {
            addCriterion("ExcessRate is not null");
            return (Criteria) this;
        }

        public Criteria andExcessrateEqualTo(BigDecimal value) {
            addCriterion("ExcessRate =", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateNotEqualTo(BigDecimal value) {
            addCriterion("ExcessRate <>", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateGreaterThan(BigDecimal value) {
            addCriterion("ExcessRate >", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ExcessRate >=", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateLessThan(BigDecimal value) {
            addCriterion("ExcessRate <", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ExcessRate <=", value, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateIn(List<BigDecimal> values) {
            addCriterion("ExcessRate in", values, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateNotIn(List<BigDecimal> values) {
            addCriterion("ExcessRate not in", values, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ExcessRate between", value1, value2, "excessrate");
            return (Criteria) this;
        }

        public Criteria andExcessrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ExcessRate not between", value1, value2, "excessrate");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIsNull() {
            addCriterion("WebAccessFlag is null");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIsNotNull() {
            addCriterion("WebAccessFlag is not null");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagEqualTo(String value) {
            addCriterion("WebAccessFlag =", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotEqualTo(String value) {
            addCriterion("WebAccessFlag <>", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagGreaterThan(String value) {
            addCriterion("WebAccessFlag >", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagGreaterThanOrEqualTo(String value) {
            addCriterion("WebAccessFlag >=", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLessThan(String value) {
            addCriterion("WebAccessFlag <", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLessThanOrEqualTo(String value) {
            addCriterion("WebAccessFlag <=", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagLike(String value) {
            addCriterion("WebAccessFlag like", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotLike(String value) {
            addCriterion("WebAccessFlag not like", value, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagIn(List<String> values) {
            addCriterion("WebAccessFlag in", values, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotIn(List<String> values) {
            addCriterion("WebAccessFlag not in", values, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagBetween(String value1, String value2) {
            addCriterion("WebAccessFlag between", value1, value2, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebaccessflagNotBetween(String value1, String value2) {
            addCriterion("WebAccessFlag not between", value1, value2, "webaccessflag");
            return (Criteria) this;
        }

        public Criteria andWebopendateIsNull() {
            addCriterion("WebOpenDate is null");
            return (Criteria) this;
        }

        public Criteria andWebopendateIsNotNull() {
            addCriterion("WebOpenDate is not null");
            return (Criteria) this;
        }

        public Criteria andWebopendateEqualTo(Date value) {
            addCriterion("WebOpenDate =", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotEqualTo(Date value) {
            addCriterion("WebOpenDate <>", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateGreaterThan(Date value) {
            addCriterion("WebOpenDate >", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateGreaterThanOrEqualTo(Date value) {
            addCriterion("WebOpenDate >=", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateLessThan(Date value) {
            addCriterion("WebOpenDate <", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateLessThanOrEqualTo(Date value) {
            addCriterion("WebOpenDate <=", value, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateIn(List<Date> values) {
            addCriterion("WebOpenDate in", values, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotIn(List<Date> values) {
            addCriterion("WebOpenDate not in", values, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateBetween(Date value1, Date value2) {
            addCriterion("WebOpenDate between", value1, value2, "webopendate");
            return (Criteria) this;
        }

        public Criteria andWebopendateNotBetween(Date value1, Date value2) {
            addCriterion("WebOpenDate not between", value1, value2, "webopendate");
            return (Criteria) this;
        }

        public Criteria andMonthsdayIsNull() {
            addCriterion("MonthsDay is null");
            return (Criteria) this;
        }

        public Criteria andMonthsdayIsNotNull() {
            addCriterion("MonthsDay is not null");
            return (Criteria) this;
        }

        public Criteria andMonthsdayEqualTo(String value) {
            addCriterion("MonthsDay =", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayNotEqualTo(String value) {
            addCriterion("MonthsDay <>", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayGreaterThan(String value) {
            addCriterion("MonthsDay >", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayGreaterThanOrEqualTo(String value) {
            addCriterion("MonthsDay >=", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayLessThan(String value) {
            addCriterion("MonthsDay <", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayLessThanOrEqualTo(String value) {
            addCriterion("MonthsDay <=", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayLike(String value) {
            addCriterion("MonthsDay like", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayNotLike(String value) {
            addCriterion("MonthsDay not like", value, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayIn(List<String> values) {
            addCriterion("MonthsDay in", values, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayNotIn(List<String> values) {
            addCriterion("MonthsDay not in", values, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayBetween(String value1, String value2) {
            addCriterion("MonthsDay between", value1, value2, "monthsday");
            return (Criteria) this;
        }

        public Criteria andMonthsdayNotBetween(String value1, String value2) {
            addCriterion("MonthsDay not between", value1, value2, "monthsday");
            return (Criteria) this;
        }

        public Criteria andDatatypeIsNull() {
            addCriterion("DataType is null");
            return (Criteria) this;
        }

        public Criteria andDatatypeIsNotNull() {
            addCriterion("DataType is not null");
            return (Criteria) this;
        }

        public Criteria andDatatypeEqualTo(String value) {
            addCriterion("DataType =", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeNotEqualTo(String value) {
            addCriterion("DataType <>", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeGreaterThan(String value) {
            addCriterion("DataType >", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeGreaterThanOrEqualTo(String value) {
            addCriterion("DataType >=", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeLessThan(String value) {
            addCriterion("DataType <", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeLessThanOrEqualTo(String value) {
            addCriterion("DataType <=", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeLike(String value) {
            addCriterion("DataType like", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeNotLike(String value) {
            addCriterion("DataType not like", value, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeIn(List<String> values) {
            addCriterion("DataType in", values, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeNotIn(List<String> values) {
            addCriterion("DataType not in", values, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeBetween(String value1, String value2) {
            addCriterion("DataType between", value1, value2, "datatype");
            return (Criteria) this;
        }

        public Criteria andDatatypeNotBetween(String value1, String value2) {
            addCriterion("DataType not between", value1, value2, "datatype");
            return (Criteria) this;
        }

        public Criteria andShipperIsNull() {
            addCriterion("Shipper is null");
            return (Criteria) this;
        }

        public Criteria andShipperIsNotNull() {
            addCriterion("Shipper is not null");
            return (Criteria) this;
        }

        public Criteria andShipperEqualTo(String value) {
            addCriterion("Shipper =", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperNotEqualTo(String value) {
            addCriterion("Shipper <>", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperGreaterThan(String value) {
            addCriterion("Shipper >", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperGreaterThanOrEqualTo(String value) {
            addCriterion("Shipper >=", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperLessThan(String value) {
            addCriterion("Shipper <", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperLessThanOrEqualTo(String value) {
            addCriterion("Shipper <=", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperLike(String value) {
            addCriterion("Shipper like", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperNotLike(String value) {
            addCriterion("Shipper not like", value, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperIn(List<String> values) {
            addCriterion("Shipper in", values, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperNotIn(List<String> values) {
            addCriterion("Shipper not in", values, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperBetween(String value1, String value2) {
            addCriterion("Shipper between", value1, value2, "shipper");
            return (Criteria) this;
        }

        public Criteria andShipperNotBetween(String value1, String value2) {
            addCriterion("Shipper not between", value1, value2, "shipper");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("Source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("Source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("Source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("Source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("Source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("Source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("Source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("Source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("Source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("Source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("Source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("Source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("Source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("Source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeIsNull() {
            addCriterion("BalaCycType is null");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeIsNotNull() {
            addCriterion("BalaCycType is not null");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeEqualTo(String value) {
            addCriterion("BalaCycType =", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeNotEqualTo(String value) {
            addCriterion("BalaCycType <>", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeGreaterThan(String value) {
            addCriterion("BalaCycType >", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeGreaterThanOrEqualTo(String value) {
            addCriterion("BalaCycType >=", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeLessThan(String value) {
            addCriterion("BalaCycType <", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeLessThanOrEqualTo(String value) {
            addCriterion("BalaCycType <=", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeLike(String value) {
            addCriterion("BalaCycType like", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeNotLike(String value) {
            addCriterion("BalaCycType not like", value, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeIn(List<String> values) {
            addCriterion("BalaCycType in", values, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeNotIn(List<String> values) {
            addCriterion("BalaCycType not in", values, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeBetween(String value1, String value2) {
            addCriterion("BalaCycType between", value1, value2, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andBalacyctypeNotBetween(String value1, String value2) {
            addCriterion("BalaCycType not between", value1, value2, "balacyctype");
            return (Criteria) this;
        }

        public Criteria andDatawinIsNull() {
            addCriterion("DataWin is null");
            return (Criteria) this;
        }

        public Criteria andDatawinIsNotNull() {
            addCriterion("DataWin is not null");
            return (Criteria) this;
        }

        public Criteria andDatawinEqualTo(String value) {
            addCriterion("DataWin =", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinNotEqualTo(String value) {
            addCriterion("DataWin <>", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinGreaterThan(String value) {
            addCriterion("DataWin >", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinGreaterThanOrEqualTo(String value) {
            addCriterion("DataWin >=", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinLessThan(String value) {
            addCriterion("DataWin <", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinLessThanOrEqualTo(String value) {
            addCriterion("DataWin <=", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinLike(String value) {
            addCriterion("DataWin like", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinNotLike(String value) {
            addCriterion("DataWin not like", value, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinIn(List<String> values) {
            addCriterion("DataWin in", values, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinNotIn(List<String> values) {
            addCriterion("DataWin not in", values, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinBetween(String value1, String value2) {
            addCriterion("DataWin between", value1, value2, "datawin");
            return (Criteria) this;
        }

        public Criteria andDatawinNotBetween(String value1, String value2) {
            addCriterion("DataWin not between", value1, value2, "datawin");
            return (Criteria) this;
        }

        public Criteria andSuppcodeIsNull() {
            addCriterion("SuppCode is null");
            return (Criteria) this;
        }

        public Criteria andSuppcodeIsNotNull() {
            addCriterion("SuppCode is not null");
            return (Criteria) this;
        }

        public Criteria andSuppcodeEqualTo(String value) {
            addCriterion("SuppCode =", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeNotEqualTo(String value) {
            addCriterion("SuppCode <>", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeGreaterThan(String value) {
            addCriterion("SuppCode >", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeGreaterThanOrEqualTo(String value) {
            addCriterion("SuppCode >=", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeLessThan(String value) {
            addCriterion("SuppCode <", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeLessThanOrEqualTo(String value) {
            addCriterion("SuppCode <=", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeLike(String value) {
            addCriterion("SuppCode like", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeNotLike(String value) {
            addCriterion("SuppCode not like", value, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeIn(List<String> values) {
            addCriterion("SuppCode in", values, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeNotIn(List<String> values) {
            addCriterion("SuppCode not in", values, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeBetween(String value1, String value2) {
            addCriterion("SuppCode between", value1, value2, "suppcode");
            return (Criteria) this;
        }

        public Criteria andSuppcodeNotBetween(String value1, String value2) {
            addCriterion("SuppCode not between", value1, value2, "suppcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNull() {
            addCriterion("VendorCode is null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNotNull() {
            addCriterion("VendorCode is not null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeEqualTo(String value) {
            addCriterion("VendorCode =", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotEqualTo(String value) {
            addCriterion("VendorCode <>", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThan(String value) {
            addCriterion("VendorCode >", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("VendorCode >=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThan(String value) {
            addCriterion("VendorCode <", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThanOrEqualTo(String value) {
            addCriterion("VendorCode <=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLike(String value) {
            addCriterion("VendorCode like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotLike(String value) {
            addCriterion("VendorCode not like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIn(List<String> values) {
            addCriterion("VendorCode in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotIn(List<String> values) {
            addCriterion("VendorCode not in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeBetween(String value1, String value2) {
            addCriterion("VendorCode between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotBetween(String value1, String value2) {
            addCriterion("VendorCode not between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeIsNull() {
            addCriterion("TransFeeType is null");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeIsNotNull() {
            addCriterion("TransFeeType is not null");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeEqualTo(String value) {
            addCriterion("TransFeeType =", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeNotEqualTo(String value) {
            addCriterion("TransFeeType <>", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeGreaterThan(String value) {
            addCriterion("TransFeeType >", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeGreaterThanOrEqualTo(String value) {
            addCriterion("TransFeeType >=", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeLessThan(String value) {
            addCriterion("TransFeeType <", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeLessThanOrEqualTo(String value) {
            addCriterion("TransFeeType <=", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeLike(String value) {
            addCriterion("TransFeeType like", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeNotLike(String value) {
            addCriterion("TransFeeType not like", value, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeIn(List<String> values) {
            addCriterion("TransFeeType in", values, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeNotIn(List<String> values) {
            addCriterion("TransFeeType not in", values, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeBetween(String value1, String value2) {
            addCriterion("TransFeeType between", value1, value2, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andTransfeetypeNotBetween(String value1, String value2) {
            addCriterion("TransFeeType not between", value1, value2, "transfeetype");
            return (Criteria) this;
        }

        public Criteria andOpenflagIsNull() {
            addCriterion("OpenFlag is null");
            return (Criteria) this;
        }

        public Criteria andOpenflagIsNotNull() {
            addCriterion("OpenFlag is not null");
            return (Criteria) this;
        }

        public Criteria andOpenflagEqualTo(String value) {
            addCriterion("OpenFlag =", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotEqualTo(String value) {
            addCriterion("OpenFlag <>", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagGreaterThan(String value) {
            addCriterion("OpenFlag >", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagGreaterThanOrEqualTo(String value) {
            addCriterion("OpenFlag >=", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLessThan(String value) {
            addCriterion("OpenFlag <", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLessThanOrEqualTo(String value) {
            addCriterion("OpenFlag <=", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLike(String value) {
            addCriterion("OpenFlag like", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotLike(String value) {
            addCriterion("OpenFlag not like", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagIn(List<String> values) {
            addCriterion("OpenFlag in", values, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotIn(List<String> values) {
            addCriterion("OpenFlag not in", values, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagBetween(String value1, String value2) {
            addCriterion("OpenFlag between", value1, value2, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotBetween(String value1, String value2) {
            addCriterion("OpenFlag not between", value1, value2, "openflag");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNull() {
            addCriterion("Industry is null");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNotNull() {
            addCriterion("Industry is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryEqualTo(String value) {
            addCriterion("Industry =", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotEqualTo(String value) {
            addCriterion("Industry <>", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThan(String value) {
            addCriterion("Industry >", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("Industry >=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThan(String value) {
            addCriterion("Industry <", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThanOrEqualTo(String value) {
            addCriterion("Industry <=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLike(String value) {
            addCriterion("Industry like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotLike(String value) {
            addCriterion("Industry not like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryIn(List<String> values) {
            addCriterion("Industry in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotIn(List<String> values) {
            addCriterion("Industry not in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryBetween(String value1, String value2) {
            addCriterion("Industry between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotBetween(String value1, String value2) {
            addCriterion("Industry not between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andStrictorderIsNull() {
            addCriterion("StrictOrder is null");
            return (Criteria) this;
        }

        public Criteria andStrictorderIsNotNull() {
            addCriterion("StrictOrder is not null");
            return (Criteria) this;
        }

        public Criteria andStrictorderEqualTo(String value) {
            addCriterion("StrictOrder =", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderNotEqualTo(String value) {
            addCriterion("StrictOrder <>", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderGreaterThan(String value) {
            addCriterion("StrictOrder >", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderGreaterThanOrEqualTo(String value) {
            addCriterion("StrictOrder >=", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderLessThan(String value) {
            addCriterion("StrictOrder <", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderLessThanOrEqualTo(String value) {
            addCriterion("StrictOrder <=", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderLike(String value) {
            addCriterion("StrictOrder like", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderNotLike(String value) {
            addCriterion("StrictOrder not like", value, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderIn(List<String> values) {
            addCriterion("StrictOrder in", values, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderNotIn(List<String> values) {
            addCriterion("StrictOrder not in", values, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderBetween(String value1, String value2) {
            addCriterion("StrictOrder between", value1, value2, "strictorder");
            return (Criteria) this;
        }

        public Criteria andStrictorderNotBetween(String value1, String value2) {
            addCriterion("StrictOrder not between", value1, value2, "strictorder");
            return (Criteria) this;
        }

        public Criteria andOrderagreeIsNull() {
            addCriterion("OrderAgree is null");
            return (Criteria) this;
        }

        public Criteria andOrderagreeIsNotNull() {
            addCriterion("OrderAgree is not null");
            return (Criteria) this;
        }

        public Criteria andOrderagreeEqualTo(String value) {
            addCriterion("OrderAgree =", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeNotEqualTo(String value) {
            addCriterion("OrderAgree <>", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeGreaterThan(String value) {
            addCriterion("OrderAgree >", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeGreaterThanOrEqualTo(String value) {
            addCriterion("OrderAgree >=", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeLessThan(String value) {
            addCriterion("OrderAgree <", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeLessThanOrEqualTo(String value) {
            addCriterion("OrderAgree <=", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeLike(String value) {
            addCriterion("OrderAgree like", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeNotLike(String value) {
            addCriterion("OrderAgree not like", value, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeIn(List<String> values) {
            addCriterion("OrderAgree in", values, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeNotIn(List<String> values) {
            addCriterion("OrderAgree not in", values, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeBetween(String value1, String value2) {
            addCriterion("OrderAgree between", value1, value2, "orderagree");
            return (Criteria) this;
        }

        public Criteria andOrderagreeNotBetween(String value1, String value2) {
            addCriterion("OrderAgree not between", value1, value2, "orderagree");
            return (Criteria) this;
        }

        public Criteria andMaxclassIsNull() {
            addCriterion("MaxClass is null");
            return (Criteria) this;
        }

        public Criteria andMaxclassIsNotNull() {
            addCriterion("MaxClass is not null");
            return (Criteria) this;
        }

        public Criteria andMaxclassEqualTo(Integer value) {
            addCriterion("MaxClass =", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassNotEqualTo(Integer value) {
            addCriterion("MaxClass <>", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassGreaterThan(Integer value) {
            addCriterion("MaxClass >", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassGreaterThanOrEqualTo(Integer value) {
            addCriterion("MaxClass >=", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassLessThan(Integer value) {
            addCriterion("MaxClass <", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassLessThanOrEqualTo(Integer value) {
            addCriterion("MaxClass <=", value, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassIn(List<Integer> values) {
            addCriterion("MaxClass in", values, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassNotIn(List<Integer> values) {
            addCriterion("MaxClass not in", values, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassBetween(Integer value1, Integer value2) {
            addCriterion("MaxClass between", value1, value2, "maxclass");
            return (Criteria) this;
        }

        public Criteria andMaxclassNotBetween(Integer value1, Integer value2) {
            addCriterion("MaxClass not between", value1, value2, "maxclass");
            return (Criteria) this;
        }

        public Criteria andHousemodeIsNull() {
            addCriterion("HouseMode is null");
            return (Criteria) this;
        }

        public Criteria andHousemodeIsNotNull() {
            addCriterion("HouseMode is not null");
            return (Criteria) this;
        }

        public Criteria andHousemodeEqualTo(String value) {
            addCriterion("HouseMode =", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeNotEqualTo(String value) {
            addCriterion("HouseMode <>", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeGreaterThan(String value) {
            addCriterion("HouseMode >", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeGreaterThanOrEqualTo(String value) {
            addCriterion("HouseMode >=", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeLessThan(String value) {
            addCriterion("HouseMode <", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeLessThanOrEqualTo(String value) {
            addCriterion("HouseMode <=", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeLike(String value) {
            addCriterion("HouseMode like", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeNotLike(String value) {
            addCriterion("HouseMode not like", value, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeIn(List<String> values) {
            addCriterion("HouseMode in", values, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeNotIn(List<String> values) {
            addCriterion("HouseMode not in", values, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeBetween(String value1, String value2) {
            addCriterion("HouseMode between", value1, value2, "housemode");
            return (Criteria) this;
        }

        public Criteria andHousemodeNotBetween(String value1, String value2) {
            addCriterion("HouseMode not between", value1, value2, "housemode");
            return (Criteria) this;
        }

        public Criteria andPricectrlIsNull() {
            addCriterion("PriceCtrl is null");
            return (Criteria) this;
        }

        public Criteria andPricectrlIsNotNull() {
            addCriterion("PriceCtrl is not null");
            return (Criteria) this;
        }

        public Criteria andPricectrlEqualTo(String value) {
            addCriterion("PriceCtrl =", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlNotEqualTo(String value) {
            addCriterion("PriceCtrl <>", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlGreaterThan(String value) {
            addCriterion("PriceCtrl >", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlGreaterThanOrEqualTo(String value) {
            addCriterion("PriceCtrl >=", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlLessThan(String value) {
            addCriterion("PriceCtrl <", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlLessThanOrEqualTo(String value) {
            addCriterion("PriceCtrl <=", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlLike(String value) {
            addCriterion("PriceCtrl like", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlNotLike(String value) {
            addCriterion("PriceCtrl not like", value, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlIn(List<String> values) {
            addCriterion("PriceCtrl in", values, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlNotIn(List<String> values) {
            addCriterion("PriceCtrl not in", values, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlBetween(String value1, String value2) {
            addCriterion("PriceCtrl between", value1, value2, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andPricectrlNotBetween(String value1, String value2) {
            addCriterion("PriceCtrl not between", value1, value2, "pricectrl");
            return (Criteria) this;
        }

        public Criteria andIsshipperIsNull() {
            addCriterion("IsShipper is null");
            return (Criteria) this;
        }

        public Criteria andIsshipperIsNotNull() {
            addCriterion("IsShipper is not null");
            return (Criteria) this;
        }

        public Criteria andIsshipperEqualTo(Integer value) {
            addCriterion("IsShipper =", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperNotEqualTo(Integer value) {
            addCriterion("IsShipper <>", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperGreaterThan(Integer value) {
            addCriterion("IsShipper >", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsShipper >=", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperLessThan(Integer value) {
            addCriterion("IsShipper <", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperLessThanOrEqualTo(Integer value) {
            addCriterion("IsShipper <=", value, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperIn(List<Integer> values) {
            addCriterion("IsShipper in", values, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperNotIn(List<Integer> values) {
            addCriterion("IsShipper not in", values, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperBetween(Integer value1, Integer value2) {
            addCriterion("IsShipper between", value1, value2, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipperNotBetween(Integer value1, Integer value2) {
            addCriterion("IsShipper not between", value1, value2, "isshipper");
            return (Criteria) this;
        }

        public Criteria andIsshipper2IsNull() {
            addCriterion("IsShipper2 is null");
            return (Criteria) this;
        }

        public Criteria andIsshipper2IsNotNull() {
            addCriterion("IsShipper2 is not null");
            return (Criteria) this;
        }

        public Criteria andIsshipper2EqualTo(Integer value) {
            addCriterion("IsShipper2 =", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2NotEqualTo(Integer value) {
            addCriterion("IsShipper2 <>", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2GreaterThan(Integer value) {
            addCriterion("IsShipper2 >", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2GreaterThanOrEqualTo(Integer value) {
            addCriterion("IsShipper2 >=", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2LessThan(Integer value) {
            addCriterion("IsShipper2 <", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2LessThanOrEqualTo(Integer value) {
            addCriterion("IsShipper2 <=", value, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2In(List<Integer> values) {
            addCriterion("IsShipper2 in", values, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2NotIn(List<Integer> values) {
            addCriterion("IsShipper2 not in", values, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2Between(Integer value1, Integer value2) {
            addCriterion("IsShipper2 between", value1, value2, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsshipper2NotBetween(Integer value1, Integer value2) {
            addCriterion("IsShipper2 not between", value1, value2, "isshipper2");
            return (Criteria) this;
        }

        public Criteria andIsclientIsNull() {
            addCriterion("IsClient is null");
            return (Criteria) this;
        }

        public Criteria andIsclientIsNotNull() {
            addCriterion("IsClient is not null");
            return (Criteria) this;
        }

        public Criteria andIsclientEqualTo(Integer value) {
            addCriterion("IsClient =", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientNotEqualTo(Integer value) {
            addCriterion("IsClient <>", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientGreaterThan(Integer value) {
            addCriterion("IsClient >", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsClient >=", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientLessThan(Integer value) {
            addCriterion("IsClient <", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientLessThanOrEqualTo(Integer value) {
            addCriterion("IsClient <=", value, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientIn(List<Integer> values) {
            addCriterion("IsClient in", values, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientNotIn(List<Integer> values) {
            addCriterion("IsClient not in", values, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientBetween(Integer value1, Integer value2) {
            addCriterion("IsClient between", value1, value2, "isclient");
            return (Criteria) this;
        }

        public Criteria andIsclientNotBetween(Integer value1, Integer value2) {
            addCriterion("IsClient not between", value1, value2, "isclient");
            return (Criteria) this;
        }

        public Criteria andDutyIsNull() {
            addCriterion("Duty is null");
            return (Criteria) this;
        }

        public Criteria andDutyIsNotNull() {
            addCriterion("Duty is not null");
            return (Criteria) this;
        }

        public Criteria andDutyEqualTo(String value) {
            addCriterion("Duty =", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotEqualTo(String value) {
            addCriterion("Duty <>", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyGreaterThan(String value) {
            addCriterion("Duty >", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyGreaterThanOrEqualTo(String value) {
            addCriterion("Duty >=", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLessThan(String value) {
            addCriterion("Duty <", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLessThanOrEqualTo(String value) {
            addCriterion("Duty <=", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLike(String value) {
            addCriterion("Duty like", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotLike(String value) {
            addCriterion("Duty not like", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyIn(List<String> values) {
            addCriterion("Duty in", values, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotIn(List<String> values) {
            addCriterion("Duty not in", values, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyBetween(String value1, String value2) {
            addCriterion("Duty between", value1, value2, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotBetween(String value1, String value2) {
            addCriterion("Duty not between", value1, value2, "duty");
            return (Criteria) this;
        }

        public Criteria andChairman2IsNull() {
            addCriterion("Chairman2 is null");
            return (Criteria) this;
        }

        public Criteria andChairman2IsNotNull() {
            addCriterion("Chairman2 is not null");
            return (Criteria) this;
        }

        public Criteria andChairman2EqualTo(String value) {
            addCriterion("Chairman2 =", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2NotEqualTo(String value) {
            addCriterion("Chairman2 <>", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2GreaterThan(String value) {
            addCriterion("Chairman2 >", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2GreaterThanOrEqualTo(String value) {
            addCriterion("Chairman2 >=", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2LessThan(String value) {
            addCriterion("Chairman2 <", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2LessThanOrEqualTo(String value) {
            addCriterion("Chairman2 <=", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2Like(String value) {
            addCriterion("Chairman2 like", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2NotLike(String value) {
            addCriterion("Chairman2 not like", value, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2In(List<String> values) {
            addCriterion("Chairman2 in", values, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2NotIn(List<String> values) {
            addCriterion("Chairman2 not in", values, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2Between(String value1, String value2) {
            addCriterion("Chairman2 between", value1, value2, "chairman2");
            return (Criteria) this;
        }

        public Criteria andChairman2NotBetween(String value1, String value2) {
            addCriterion("Chairman2 not between", value1, value2, "chairman2");
            return (Criteria) this;
        }

        public Criteria andDuty2IsNull() {
            addCriterion("Duty2 is null");
            return (Criteria) this;
        }

        public Criteria andDuty2IsNotNull() {
            addCriterion("Duty2 is not null");
            return (Criteria) this;
        }

        public Criteria andDuty2EqualTo(String value) {
            addCriterion("Duty2 =", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2NotEqualTo(String value) {
            addCriterion("Duty2 <>", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2GreaterThan(String value) {
            addCriterion("Duty2 >", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2GreaterThanOrEqualTo(String value) {
            addCriterion("Duty2 >=", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2LessThan(String value) {
            addCriterion("Duty2 <", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2LessThanOrEqualTo(String value) {
            addCriterion("Duty2 <=", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2Like(String value) {
            addCriterion("Duty2 like", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2NotLike(String value) {
            addCriterion("Duty2 not like", value, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2In(List<String> values) {
            addCriterion("Duty2 in", values, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2NotIn(List<String> values) {
            addCriterion("Duty2 not in", values, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2Between(String value1, String value2) {
            addCriterion("Duty2 between", value1, value2, "duty2");
            return (Criteria) this;
        }

        public Criteria andDuty2NotBetween(String value1, String value2) {
            addCriterion("Duty2 not between", value1, value2, "duty2");
            return (Criteria) this;
        }

        public Criteria andTelephone2IsNull() {
            addCriterion("Telephone2 is null");
            return (Criteria) this;
        }

        public Criteria andTelephone2IsNotNull() {
            addCriterion("Telephone2 is not null");
            return (Criteria) this;
        }

        public Criteria andTelephone2EqualTo(String value) {
            addCriterion("Telephone2 =", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2NotEqualTo(String value) {
            addCriterion("Telephone2 <>", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2GreaterThan(String value) {
            addCriterion("Telephone2 >", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2GreaterThanOrEqualTo(String value) {
            addCriterion("Telephone2 >=", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2LessThan(String value) {
            addCriterion("Telephone2 <", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2LessThanOrEqualTo(String value) {
            addCriterion("Telephone2 <=", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2Like(String value) {
            addCriterion("Telephone2 like", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2NotLike(String value) {
            addCriterion("Telephone2 not like", value, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2In(List<String> values) {
            addCriterion("Telephone2 in", values, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2NotIn(List<String> values) {
            addCriterion("Telephone2 not in", values, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2Between(String value1, String value2) {
            addCriterion("Telephone2 between", value1, value2, "telephone2");
            return (Criteria) this;
        }

        public Criteria andTelephone2NotBetween(String value1, String value2) {
            addCriterion("Telephone2 not between", value1, value2, "telephone2");
            return (Criteria) this;
        }

        public Criteria andMobile2IsNull() {
            addCriterion("Mobile2 is null");
            return (Criteria) this;
        }

        public Criteria andMobile2IsNotNull() {
            addCriterion("Mobile2 is not null");
            return (Criteria) this;
        }

        public Criteria andMobile2EqualTo(String value) {
            addCriterion("Mobile2 =", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotEqualTo(String value) {
            addCriterion("Mobile2 <>", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2GreaterThan(String value) {
            addCriterion("Mobile2 >", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2GreaterThanOrEqualTo(String value) {
            addCriterion("Mobile2 >=", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2LessThan(String value) {
            addCriterion("Mobile2 <", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2LessThanOrEqualTo(String value) {
            addCriterion("Mobile2 <=", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2Like(String value) {
            addCriterion("Mobile2 like", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotLike(String value) {
            addCriterion("Mobile2 not like", value, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2In(List<String> values) {
            addCriterion("Mobile2 in", values, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotIn(List<String> values) {
            addCriterion("Mobile2 not in", values, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2Between(String value1, String value2) {
            addCriterion("Mobile2 between", value1, value2, "mobile2");
            return (Criteria) this;
        }

        public Criteria andMobile2NotBetween(String value1, String value2) {
            addCriterion("Mobile2 not between", value1, value2, "mobile2");
            return (Criteria) this;
        }

        public Criteria andTransferflagIsNull() {
            addCriterion("TransferFlag is null");
            return (Criteria) this;
        }

        public Criteria andTransferflagIsNotNull() {
            addCriterion("TransferFlag is not null");
            return (Criteria) this;
        }

        public Criteria andTransferflagEqualTo(String value) {
            addCriterion("TransferFlag =", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagNotEqualTo(String value) {
            addCriterion("TransferFlag <>", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagGreaterThan(String value) {
            addCriterion("TransferFlag >", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagGreaterThanOrEqualTo(String value) {
            addCriterion("TransferFlag >=", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagLessThan(String value) {
            addCriterion("TransferFlag <", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagLessThanOrEqualTo(String value) {
            addCriterion("TransferFlag <=", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagLike(String value) {
            addCriterion("TransferFlag like", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagNotLike(String value) {
            addCriterion("TransferFlag not like", value, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagIn(List<String> values) {
            addCriterion("TransferFlag in", values, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagNotIn(List<String> values) {
            addCriterion("TransferFlag not in", values, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagBetween(String value1, String value2) {
            addCriterion("TransferFlag between", value1, value2, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransferflagNotBetween(String value1, String value2) {
            addCriterion("TransferFlag not between", value1, value2, "transferflag");
            return (Criteria) this;
        }

        public Criteria andTransfercodeIsNull() {
            addCriterion("TransferCode is null");
            return (Criteria) this;
        }

        public Criteria andTransfercodeIsNotNull() {
            addCriterion("TransferCode is not null");
            return (Criteria) this;
        }

        public Criteria andTransfercodeEqualTo(String value) {
            addCriterion("TransferCode =", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeNotEqualTo(String value) {
            addCriterion("TransferCode <>", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeGreaterThan(String value) {
            addCriterion("TransferCode >", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeGreaterThanOrEqualTo(String value) {
            addCriterion("TransferCode >=", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeLessThan(String value) {
            addCriterion("TransferCode <", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeLessThanOrEqualTo(String value) {
            addCriterion("TransferCode <=", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeLike(String value) {
            addCriterion("TransferCode like", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeNotLike(String value) {
            addCriterion("TransferCode not like", value, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeIn(List<String> values) {
            addCriterion("TransferCode in", values, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeNotIn(List<String> values) {
            addCriterion("TransferCode not in", values, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeBetween(String value1, String value2) {
            addCriterion("TransferCode between", value1, value2, "transfercode");
            return (Criteria) this;
        }

        public Criteria andTransfercodeNotBetween(String value1, String value2) {
            addCriterion("TransferCode not between", value1, value2, "transfercode");
            return (Criteria) this;
        }

        public Criteria andIsdummyIsNull() {
            addCriterion("IsDummy is null");
            return (Criteria) this;
        }

        public Criteria andIsdummyIsNotNull() {
            addCriterion("IsDummy is not null");
            return (Criteria) this;
        }

        public Criteria andIsdummyEqualTo(Integer value) {
            addCriterion("IsDummy =", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyNotEqualTo(Integer value) {
            addCriterion("IsDummy <>", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyGreaterThan(Integer value) {
            addCriterion("IsDummy >", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsDummy >=", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyLessThan(Integer value) {
            addCriterion("IsDummy <", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyLessThanOrEqualTo(Integer value) {
            addCriterion("IsDummy <=", value, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyIn(List<Integer> values) {
            addCriterion("IsDummy in", values, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyNotIn(List<Integer> values) {
            addCriterion("IsDummy not in", values, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyBetween(Integer value1, Integer value2) {
            addCriterion("IsDummy between", value1, value2, "isdummy");
            return (Criteria) this;
        }

        public Criteria andIsdummyNotBetween(Integer value1, Integer value2) {
            addCriterion("IsDummy not between", value1, value2, "isdummy");
            return (Criteria) this;
        }

        public Criteria andCategoryeditIsNull() {
            addCriterion("CategoryEdit is null");
            return (Criteria) this;
        }

        public Criteria andCategoryeditIsNotNull() {
            addCriterion("CategoryEdit is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryeditEqualTo(String value) {
            addCriterion("CategoryEdit =", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditNotEqualTo(String value) {
            addCriterion("CategoryEdit <>", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditGreaterThan(String value) {
            addCriterion("CategoryEdit >", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditGreaterThanOrEqualTo(String value) {
            addCriterion("CategoryEdit >=", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditLessThan(String value) {
            addCriterion("CategoryEdit <", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditLessThanOrEqualTo(String value) {
            addCriterion("CategoryEdit <=", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditLike(String value) {
            addCriterion("CategoryEdit like", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditNotLike(String value) {
            addCriterion("CategoryEdit not like", value, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditIn(List<String> values) {
            addCriterion("CategoryEdit in", values, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditNotIn(List<String> values) {
            addCriterion("CategoryEdit not in", values, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditBetween(String value1, String value2) {
            addCriterion("CategoryEdit between", value1, value2, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andCategoryeditNotBetween(String value1, String value2) {
            addCriterion("CategoryEdit not between", value1, value2, "categoryedit");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNull() {
            addCriterion("SiteID is null");
            return (Criteria) this;
        }

        public Criteria andSiteidIsNotNull() {
            addCriterion("SiteID is not null");
            return (Criteria) this;
        }

        public Criteria andSiteidEqualTo(Integer value) {
            addCriterion("SiteID =", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotEqualTo(Integer value) {
            addCriterion("SiteID <>", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThan(Integer value) {
            addCriterion("SiteID >", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidGreaterThanOrEqualTo(Integer value) {
            addCriterion("SiteID >=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThan(Integer value) {
            addCriterion("SiteID <", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidLessThanOrEqualTo(Integer value) {
            addCriterion("SiteID <=", value, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidIn(List<Integer> values) {
            addCriterion("SiteID in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotIn(List<Integer> values) {
            addCriterion("SiteID not in", values, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidBetween(Integer value1, Integer value2) {
            addCriterion("SiteID between", value1, value2, "siteid");
            return (Criteria) this;
        }

        public Criteria andSiteidNotBetween(Integer value1, Integer value2) {
            addCriterion("SiteID not between", value1, value2, "siteid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}